Interested to Buy Any Domain ? << Click Here >> for more details...
On a day i load 10 rows in my target and on nextday i get 10
more rows to add in target. But out of 10 - 5 records are
send them to target?how i can insert the remaining records
- 1 Answers
- 3126 Views
- I also Faced
- E-Mail Answers
Answer Posted / nayek007
1. If stage table have some unique identifier then lookup wrt target table and skip the already inserted rows.
2. Use a flag in stage area..update that record when inserted into target table...and in sq filter the data set using that field.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a filter transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What could be the possible resons of locks by user?
Define filter transformation?
What is the difference between router and filter?
What are the restrictions of union transformation?
tell me about your project functionality
Explain how to import oracle sequence into informatica?
What do you understand by SOA of Informatica?
Explain pmcmd command usage in informatica
What is repository manager?
