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
- 6077 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
Describe an informatica powercenter?
can anyone explain me about retail domain project in informatica?
What are the mapping parameters and mapping variables?
Explain why we use partitioning the session in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain the tuning lookup transformation - informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is meant by query override?
What is joiner transformation in informatica?
Explain Dataware house architecture .how data flow from intial to end?
What is the function of aggregator transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is informatica metadata and where is it stored?
Explain the different lookup methods used in informatica?
What is data caches/ index caches?
