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
- 3046 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
How can we create index after completion of load process?
How to create Target definition for flat files?
What is informatica? Why do we need it?
What is intricate mapping?
Which development components of informatica have the highest usage?
Whats there in global repository
What is Session and Batches?
What are the different components of powercenter?
What is blocking transformation?
What is the function of aggregator transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How can you differentiate between powercenter and power map?
How many numbers of sessions can one group in batches?
pmscmd startworkflow -sv
Explain the aggregator transformation?
