Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 39167 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
Answer Posted / eswar
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 ? | 21 Yes | 2 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
what is the -ve test case in your project.
What is an unconnected transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the benefit of session partitioning?
what are 3 tech challenges/ common issues you face?
How to generate sequence numbers without using the sequence generator transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to do unit testing in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What all are steps in up gradation of Informatica server?
What is flashback table ? Advance thanks
What is the fact table?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
