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
- 3077 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 are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is flashback table ? Advance thanks
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the uses of etl tools?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Does an informatica transformation support only aggregate expressions?
how to load dimension table and fact table. plz tell me the steps.
What are the designer tools for creating transformations?
What is the function of look up transformation?
what is size of u r database?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to do unit testing in informatica? How to load data in informatica ?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain sessions. Explain how batches are used to combine executions?
Explain Dataware house architecture .how data flow from intial to end?
