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
- 11151 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
How can we delete duplicate rows from flat files?
difference between repository database and repository service?
What is flashback table ? Advance thanks
without table how to come first record only in oracle?
Explain the aggregator transformation?
What is an active transformation?
Explain the tuning lookup transformation - informatica
Implementation methodology
What is dimensional table? Explain the different dimensions.
What is the difference between writing a joiner query in ANSI style and THETA style?
what is the -ve test case in your project.
Explain the pipeline partition with real time example?
What is a mapplet/worklet in informatica?
What is dimensional table?
explain abt ur project architecture?
