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
What are the types of caches in lookup? Explain them.
What is xml source qualifier transformation in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the types of data warehouses?
How can we create index after completion of load process?
Enlist the advantages of informatica.
How to generate sequence numbers?
What is a sorter transformation?
How can you validate all mappings in the repository simultaneously?
Have you worked with/created Parameter file
Explain pushdown optimization $pushdownconfig parameter - informatica
What is rank transformation?
Repository user profiles
During the running session, output files are created by informatica server. Enlist few of them.