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 add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
- 4 Answers
- 8432 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / arpit
For this a SCD type2 mapping has to be created which will handle both update and insert. This mapping will be having 2 target instances i.e. one instance for updating and other is for inserting records. Use router to divide the rows in two groups i.e. update and insert. In the pipeline for update target instance use the update strategy transformation for update.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
tell me the rules and responsblites in our project(my project is development)
What are the settings that you use to configure the joiner transformation?
Performance tuning in UNIX for informatica mappings?
What is the reusable transformation?
How to create Target definition for flat files?
If informatica has its scheduler why using third party scheduler?
What is joiner transformation in informatica?
What is update strategy transform?
Tell me about MD5 functions in informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Mention few advantages of router transformation over filter transformation.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
EXL informatica Questions
How we can create indexes after completing the loan process?
