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
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 |
Explain about power designer data modeling software?
What is partitioning? Explain different types of partitioning?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
when will use SQL override in a lookup transformation?
what is session partitioning?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
how do u identify the changed records in operational data?
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,
What are three tier systems in etl?
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
How etl testing is different from database testing?