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 is Active lock explain
In informatica workflow manager, how many repositories can be created?
list out all the transformations which use cache?
What are the different ways to implement parallel processing in informatica?
Explain what transformation and how many are there in informatica?
Explain about cumulative Sum or moving sum?
tell me about your project functionality
Explain the scenario which compels informatica server to reject files?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what is INFORMATICA TESTING process
What all are steps in up gradation of Informatica server?
What could be the possible resons of locks by user?
What is informatica metadata and where is it stored?
Performance tuning in UNIX for informatica mappings?