Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 38798 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
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
Explain the types of transformations?
What is pmcmd command?
What are the tuning techniques you applied during your last project
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Name the different lookup cache(s)?
How can one identify whether mapping is correct or not without connecting session?
What is the need for an etl tool?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain sessions and how many types of sessions are there?
What are the different transaction levels available in transaction control transformation?
How to open an older version of an object in the workspace?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is the Default Source Option For Update Strategy Transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
