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?
Answer Posted / ora_001
Can we use merge here ?
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How to generate sequence numbers?
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 to generate sequence numbers without using the sequence generator transformation?
Global and Local shortcuts. Advantages.
How to join three sources using joiner?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the different components of powercenter?
What is main use of mapplet?
What is a filter transformation?
What does role playing dimension mean?
Define pmcmd command?
what is the size of your data warehousing?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is blocking transformation?
What are the differences between oltp and olap?