SAP BW IQ - Part 3

21. How do you transform Open Hub Data?

A:  Using BADI we can transform Open Hub Data according to the destination  
      requirement.

22. What is ODS?
 

A:   Operational DataSource is used for detailed storage of data. 

      We can overwrite data in the ODS. The data is stored in transparent tables.

23. What are BW Statistics and what is its use?
 

A:   They are group of Business Content InfoCubes which are used to measure  
      performance for Query and Load Monitoring. 

      It also shows the usage of aggregates, OLAP and Warehouse management.  

24. What are the steps to extract data from R/3?
 

A:   §       Replicate DataSources

§       Assign InfoSources

§       Maintain Communication Structure and Transfer rules

§       Create and InfoPackage

§       Load Data

25. What are the delta options available when you load from flat file?
 

A:  The 3 options for Delta Management with Flat Files:

                        o Full Upload
                        o New Status for Changed records (ODS Object only)
                        o Additive Delta (ODS Object & InfoCube)