Interested to Buy Any Domain ? << Click Here >> for more details...
Hi all, i am new to this site and new to Informatica too. I
have few questions regarding that.
1) When we load flat files into target tables how do we
identify duplicates? and where do load the duplicate
records for further reference?
2) How do we do chage data capture? Is this Slowly changing
Dimension technique?
Thanks in Advance
- 3 Answers
- 7286 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
take a router transformation and pass the records through the router transformation and write the logic as if setvarcount()<=1 then send to one target and if setvarcount()>1 then rout them to second target then u can easily avoid duplicates and also u can verify them for future use. try this else correct me
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a difference between complete, stop and abort?
What is informatica etl tool?
What is an unconnected transformation?
What is the difference between Active and Passive transformation?
Which version configuration tool used in ur project?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
According to his methodology what all you need before you build a datawarehouse
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is informatica?
Design a mapping to load a target table with the following values from the above source?
What are the different types of repositories created using informatica?
How to generate sequence numbers without using the sequence generator transformation?
Define mapplet?
How to generate sequence numbers?
Describe data concatenation?
