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
- 7277 Views
- I also Faced
- E-Mail Answers
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 is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is union transformation?
Explain how to import oracle sequence into informatica?
What is incremental aggregation?
what are the Methods For Creating Reusable Transformations?
What is aggregator transformation in informatica?
How to generate sequence numbers using expression transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is decode in static cache?
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?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Informatica Checkpoints
What is the Process to creating lookup transformation in informatica
Explain what are the different versions of informatica?
Can u generate reports in Informatica?
