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
- 2970 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 to call shell scripts from informatica?
What is data movement mode in Informatica and difference between them?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can we create two repositories on same database instance in oracle?
Explain your project of banking domian.
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain sessions?
how many types of dimensions are available in informatica?
What are the types of caches in lookup? Explain them.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What does reusable transformation mean?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How many input parameters can exist in an unconnected lookup?
What is an active transformation?
How are indexes created after completing the load process?
