Tranformation file issue-BPC 7.5 SP6

41 Views

Hi Experts,

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_

*MAPPING

ID=ID

COSTCENTER=0COSTCENTER

START_DT=ZBPC_STDT

PAY_SCALE_GRADE=0PAYSCALEGR

EE_GROUP=ZBPC_EGRP

PAY_CURRENCY=0CURRENCY

GEO_HIER_PARENT=*STR(G_)+0COMP_CODE

EMP_PC_WORKED=0EMPLPCT

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.

Sanjeev