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
- 3125 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what is polling?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
How do you change parameter when you move it from development to production.
How to recover the standalone session?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
What are the connected or unconnected transforamations?
How is union transformation utilized?
What are active transformations? Name them.
Which means the first record should come as last record and last record should come as first record and load into the target file?
without using emailtask how will send a mail from informatica?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
which one is better performance wise joiner or look up
Teradata 
