What is incremental aggregation and how it is done?
Answer Posted / sivaprasad
Gradually to synchronize the target data with source data,
there are further 2 techniques:-
Refresh load - Where the existing data is truncated and
reloaded completely.
Incremental - Where delta or difference between target and
source data is dumped at regular intervals. Timsetamp for
previous delta load has to be maintained.
Is This Answer Correct ? | 15 Yes | 13 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Write the different tools in the workflow manager?
What all join we can perform in LOOKUP transformation?
What are the various types of transformation?
What do think which one is the better joiner or look up?
update strategy transformation in informatica
difference between repository database and repository service?
Explain what transformation and how many are there in informatica?
What is a node in Informatica?
What are mapplets?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Define filter transformation?
Briefly describe lookup transformation?
Does an informatica transformation support only aggregate expressions?