When you are copying or importing data between applications and need to map the dimensions that are different, you can create a transformation file to map the dimensions.
The following table contains a list of the dimensions in a sample source and target application:
Source Application |
Target Application |
Category Account Entity Time Rptcurrency Intco Datasrc |
Cat Acc Ent Tim Currency Int Dat |
To map the dimensions from the source application to the target application, you can create a transformation file such as the following:
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER =
SKIP = 0
SKIPF =
CREDITNEGATIVE=NO
CONVERTAMOUNTWDIM=
MAXREJECTCOUNT=
VALIDATERECORDS=YES
*MAPPING
cat=category
Acc=Account
Ent = Entity
Tim=time
Currency=Rptcurrency
int=intco
dat=Datasrc
*CONVERSION