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
- 7411 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
Clarify the aggregator change?
What is parallel processing in informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Scheduling properties,whats the default (sequential)
What is data caches/ index caches?
What happens when a session fails and you click on recover?
What do you understand by term role-playing dimension?
Name the different lookup cache(s)?
What are the transformations that are not supported in mapplet?
Where are the source flat files kept before running the session?
How to load the data from people soft hrm to people soft erm using informatica?
Can we override a native sql query within informatica?
What is dynamic cache?
Explain how many types of dimensions are available in informatica?
How many dimensions are there in informatica?
