in sap bw project at what scenario generic extraction is
used and why explain and also tell why you used calendar day
option
explain?
Answer Posted / 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 |
Post New Answer View All Answers
how many steps are there in etl process?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
when will use SQL override in a lookup transformation?
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain about the data integration suite features?
Explain what are the various etl tools in the market?
how to load the data to fact table?
What are the various tools used in etl?
Do we need an ETL tool? When do we go for the tools in the market?
what is Forward,Reverse and Re_engineering?
Mention few test cases and explain them?
What is staging area referring to?
what is the meaning of upgradation of Repository?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is an ETL or ETT? And what are the different types?