uploading transaction file via flat file
In the transformation file, we maintain the mapping as follow:
Entity_Dimension = *COL(1)
KF_Dimension = *COL(2)
and in the text file, we maintain as follow:
What should I put in Mapping section in the transformation file if I want to maintain the text file as below (if it's possible):
|Entity_Dimension||KF_Dimension quantity member||KF_Dimension Total Member|
Thanks in advance.