In this section, we will see how to create transformation.
20) Replicate the data source, select the source system, right click and select 'Replicate DataSources'
20) Replicate the data source, select the source system, right click and select 'Replicate DataSources'
21) Select the data source as RSDS DataSource
22) Select the InfoCube and right click to 'Create Transformation'
23) Select Source and Target for Transformation
24) System will propose the mapping, incase system does not propose, select the InfoObject and drop for mapping
25) For 0CALMONTH, a constant will be used in this case, define the constant
26) After defining, press 'Transfer Values'
27) Check and activate the transformation
In the next section, we will see how to create Data Transfer Process and load data in InfoCube