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
- 7422 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 difference between stop and abort in informatica
How can we remove the duplicates from flat file source?
What is union transformation in informatica?
Please let me know how to make encryption and decryption with example?
Explain in detail about scd type 1 through mapping.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
In which transformation you cannot drag ports into it?
What are the types of lookup transformation?
In how many ways we can create ports?
What is target load order?
Describe data concatenation?
What are batches?
Explain Dataware house architecture .how data flow from intial to end?
What is the difference between informatics 7x and 8x and what is latest version?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
