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
- 7276 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
what is INFORMATICA TESTING process
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is Index Caches size?
what is unit testing?tell me proceedure
What are the reusable transformations?
What is the advantage of informatica?
What are connected or unconnected transformations?
what are 3 tech challenges/ common issues you face?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the popular informatica products?
What is transformation?
How will the document be delivered to me?
lookup transformation with screenshots
