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
Answer Posted / guest
BEFORE LOADING THE DATA IN TO THE TARGET , U CAN CRETAE THE
ROUTER TRANSFORMATION AND PASS THE CONDITION FOR DUPLICATE
ROWS .
YES SCD EXPLAINS THE CHANGED DATA CAPTURE IN TO THE TARGET
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
Explain lookup transformation in informatica
what are the deliverables?in your project?
What is data caches/ index caches?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the differences between oltp and olap?
tell me about your project functionality
wat are deployement groups in informatica, how it will be used for developers
To import the flat file definition into the designer where should the flat file be placed?
What is persistent lookup cache?
As union transformation gives UNION ALL output, how you will get the UNION output?
How will the document be delivered to me?
How many numbers of sessions can one group in batches?
Global and Local shortcuts. Advantages.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?