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
- 7230 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 the way to execute pl/sql script using informatica mapping?
What are the components of workflow manager?
When do you use sql override in a lookup transformation?
Difference between Data and Index Caches?
What are the different types of olap? Give an example?
How to generate sequence numbers using expression transformation?
How to load data in informatica ?
if we have a delimiters at unwanted places in a flat file how can we over come those.
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.
How to create Target definition for flat files?
What are some examples of informatica etl programs?
What do mean by local and global repository?
What all are steps in up gradation of Informatica server?
what is INFORMATICA TESTING process
What is update strategy transform?
