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 / ap
Use the target table as lookup and check for the existance
of the rows from source in the lookup. If the row already
exists then ignore and only pass the new rows to the target.
Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
What is the fact table?
what is $$$$?
Performance tuning( what you did in performance tuning)
How you prepared reports for OLAP?
server hot-ws270 is connect to Repository B. What does it mean?
How do you take back up of repository?
Explain about Informatica server process that how it works relates to mapping variables?
What is the benefit of partitioning a session?
what is the size of u r source(like file or table)?
Explain sql transformation in script mode examples in informatica
Partition, what happens if the specified key range is shorter and longer
Enlist the tasks for which source qualifier transformation is used.
How can you increase the performance in joiner transformation?
What are the tasks that can be performed using sq?
What is joiner transformation in informatica?