in sap bw project at what scenario generic extraction is
used and why explain and also tell why you used calendar day
option
explain?

Answers were Sorted based on User's Feedback



in sap bw project at what scenario generic extraction is used and why explain and also tell why yo..

Answer / sandeep

We have built a generic data source to simulate
0material_attr, which is a business content data source.
Why? - My requirement was to do reporting on 0material
master, so to do reporting on 0material we converted that as
the data target, which can be loaded only with flexible
update and this should be assigned with a transaction data
source, but the business content data source 0material_attr
is master data attribute data source, which can’t be used
up, so to solve this problem we have built the transaction
data, data source ZMATERIAL_ATTR which is simulating the
0material_attr.

Is This Answer Correct ?    5 Yes 4 No

in sap bw project at what scenario generic extraction is used and why explain and also tell why yo..

Answer / pradeep sridhara

When we Don't have any business content data source is
readymadely available , we go for generic datasource

Even if the business content datasource is available and it
is is being used up, if u want to create the same kind of
extractor we go for generic extraction

calday is one of the ways of setting up the delta in
generic extraction, we can run only once per day that too
at the end the day or clock to minimize the missing of delta
records

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More ETL Interview Questions

Define slowly changing dimensions (SCD)?

0 Answers  


what are Lookup caches options? Including persistent caches.

1 Answers  


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  






What is etl process? How many steps etl contains?

0 Answers  


Two different admin users created for repository are________and_________.

1 Answers  


what is HISTOGRAM? how to generate statistics?

1 Answers  


WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,


Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  


what are the different Reporting and ETL tools available in the market?

3 Answers  


What are the different Lookup methods used in Informatica?

0 Answers  


Categories