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
- 7104 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinu
--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 |
Post New Answer View All Answers
Separate from an archive server and a powerhouse?
What are some examples of informatica etl programs?
What is a connected transformation?
What is an expression transformation in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Differentiate between source qualifier and filter transformation?
Explain the different dimensions.
Enlist the various types of transformations.
How to elaborate powercenter integration service?
Explain about Informatica server process that how it works relates to mapping variables?
What is a mapplet/worklet in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to update a particular record in target with out running whole workflow?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to go to the older version for a mapping?
