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
- 7300 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 are the types of error logs available in Informatica?
Can you create a flatfile target
What do you mean by filter transformation?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
what is workflow varible
If there are more than one sessions running parallel in a worklet, which will be the last session ?
what are the types of Data warehousing ?
HOW TO YOU LOAD TIME DIMENSION
what is the look up transformation?
connected and unconnected lookups?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Where are the source flat files kept before running the session?
Teradata 
