What is the use of Transformation and how the mapping is done in BW?

1.	What is the use of Transformation and how the mapping is done in BW?
Answer» Transformation process is used to perform data consolidation, cleansing and data integration. When data is loaded from one BI object to other BI object, transformation is applied on the data. Transformation is used to convert a field of source into the target object format. Transformation rules − Transformation rules are used to map source fields and target fields. Different rule types can be used for transformation.

Answer»

Transformation process is used to perform data consolidation, cleansing and data integration. When data is loaded from one BI object to other BI object, transformation is applied on the data. Transformation is used to convert a field of source into the target object format.

Transformation rules −

Transformation rules are used to map source fields and target fields. Different rule types can be used for transformation.

Discussion

No Comment Found

Related InterviewSolutions

What is UD connect in SAP BW system? How does it allow reporting in BI system?
What is the use of DB connection in SAP BW data acquisition?
How data is stored in PSA?
In SAP BW, is it possible to have multiple data sources have one InfoSource?
To load the data from a file source system, what is requirement in BI system?
While loading data from flat files, when separators are used inconstantly. How this will read in BI load?
What is the use of Navigational attributes?
Explain the difference between InfoCube and ODS?
What is Partition of an InfoCube?
How can you achieve performance optimization in SAP Data Warehouse?

What is the use of Transformation and how the mapping is done in BW?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment