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
- 7524 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
--When we load flat files into target tables how do we
identify duplicates?
I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans
(I think “it will help u” Any ,,,Let me know,,
srinu.srinuvas@gmail.com)
--where do load the duplicate records for further
reference?
From 2nd router Transfromation we have a Separate Target
Table.
--How do we do chage data capture? Is this Slowly changing
Dimension technique?
chage data capture(CDC) Mean newly Inserts, Updates
Based on Data loading time,,
This Inserts, Updates only Slowly changing Dimension
technique.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / 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 |
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
How to eliminate duplicates in FF and oracle both
How does the aggregator transformation handle null values?
What is rank transformation in informatica
What is the maplet?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
What you know about transaction control transformation?
What is a data modeling?
What is a filter transformation and why it is an active one?
tell me the push down optimization
what is the difference between lookupoveride and joiner?
How to implement security measures using repository manager?
Teradata 
