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
- 3129 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 |
Can yoU use the maping parameters or variables created in one maping into another maping?
what is target load plan
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What are the Advantages of de normalized data?
How can we handle two sessions in informatica?
Separate from an archive server and a powerhouse?
How to start a workflow using pmcmd command?
How to load time dimension?
How will you check the bottle necks in informatica? From where do you start checking?
if i am having 10 records in source, i want 20 records in target...how will you do it
in reporting we add some new objects,how we get the count of the newly added objects to the report
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Teradata 
