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
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 is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
design of staging area?
Have you worked with/created Parameter file
What's the layout of parameter file (what does a parameter file contain?)?
How can you increase the performance in joiner transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Is there any way to read the ms excel datas directly into informatica?
How to generate sequence numbers using expression transformation?
What is a rank transform?
what are 3 tech challenges/ common issues you face?
In which transformation you cannot drag ports into it?
What is an aggregator transformation?
What is status code in informatica?
How to join three sources using joiner?