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
- 7121 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 does refresh system mean, and what are its distinctive choice?
What is different between the data warehouse and data mart?
what are 3 tech challenges/ common issues you face?
Explain the features of connected and unconnected lookup.
What is workflow? What are the components of workflow manager?
What is the difference between a repository server and a powerhouse?
What are the different types of repositories created using informatica?
How to convert multiple rows to single row (multiple columns) in informatica
What is a code page?
Suppose we do not group by on any ports of the aggregator what will be the output?
can anyone explain me about retail domain project in informatica?
Describe an informatica powercenter?
What is the use of target designer?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can you validate all mappings in the repository simultaneously?
