Interested to Buy Any Domain ? << Click Here >> for more details...
source table have 3 records? and it is sucessfully loaded
into target. and 4more records is added in to source .that
means 7 records now in source. we have to load the
remaining 4 records into the same trgt table with maintian
top 3 records. how ?can any one give me the data flow of
this logic plz?
- 5 Answers
- 10983 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kishore
Hi this will do by using INCREMENTAL LOADING.
We should delete records on staging area by using presql on
target(staging).
now staging having only new records..
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is an active transformation?
What is the use of an aggregator cache file?
what is Active lock explain
What is lookup change?
What are the differences between source qualifier and joiner transformation?
What is depict expression change?
How would you join a node to the already existing domain?
How to convert multiple rows to single row (multiple columns) in informatica
What is an expression transformation in informatica?
What happens when a session fails and you click on recover?
What is aggregator transformation in informatica?
Explain the difference between mapping parameter and mapping variable?
Differentiate between joiner and lookup transformation?
What is informatica metadata and where is it stored?
What is data caches/ index caches?
