I have a question on my transformation file. When i remove the first row in MAPPING section then my transformation file works. But when i see the loaded data ID is loaded with out preceeding zeroes and prefix (P_). I want to see the data in BPC dimension as P_00000001(3 preceeding zeroes before the personnel number).
Please correct me if there is any wrong in my transformation file.
I did change the transformation file with ID=ID but it does load with out zeroes both with internal and external format like 1,2 8,20 in ID column, but at the backend it has leading zeroes with out prefix P_
At the same time i dont see any description in EVDESCRIPTION for personnel no. Do i need to put EVDESCRIPTION as well in transformation file. Awaiting your replys.