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
- 7118 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 are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can you generate reports in informatica?
What if the source is a flat-file?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What all are steps in up gradation of Informatica server?
Explain the code page compatibility?
draw informatica architecture 8.6 ?
Which are the different editions of informatica powercenter that are available?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what are 3 tech challenges/ common issues you face?
What is the different lookup cache(s)?
Whats there in global repository
How does a rank transform differ from aggregator transform functions max and min?
How do we call shell scripts from informatica?
What is the difference between a repository server and a powerhouse?
