Issue in transformation
I am having strange issue in transformation. I have mapping as below:
My result should be unique based on employee and fiscal year. I have some custom logic in end routine on fiscal year and based on that it should have value.
While running DTP, it is giving me an error of duplicate data record even though the data is unique. After so much analyzing, i came to know that the code is not taking the fiscal year as key.