what is incremantal aggregation?
Answer / swetha
When using incremental aggregation, you apply captured
changes in the source to aggregate calculations in a
session. If the source changes only incrementally and you
can capture changes, you can configure the session to
process only those changes. This allows the Informatica
Server to update your target incrementally, rather than
forcing it to process the entire source and recalculate the
same calculations each time you run the session.
Is This Answer Correct ? | 4 Yes | 0 No |
What is the need of building a data warehouse?
how you will maintain version?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What are the types of data that passes between informatica server and stored procedure?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a node in Informatica?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
replace multiple spaces with single space.
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
How can you display only hidden files in UNIX
Explain the types of lookup transformation?