in sap bw project at what scenario generic extraction is
used and why explain and also tell why you used calendar day
option
explain?
- 2 Answers
- 9749 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
what is the use of server?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what are the reports developed in sap bw project and what is the requirement for developing it?
what is the indicator file and where it is used?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Which type or t/s is used to convert rows into column & column into rows
Which transformation we use to convert 'NA' to 'Not Available'
What is grain of fact?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
When do we analyze the tables? How do we do it?
how do u really know that paging to disk is happening while u are using a lookup transform?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
Teradata 
