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
- 7292 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
--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 |
Answer / guest
BEFORE LOADING THE DATA IN TO THE TARGET , U CAN CRETAE THE
ROUTER TRANSFORMATION AND PASS THE CONDITION FOR DUPLICATE
ROWS .
YES SCD EXPLAINS THE CHANGED DATA CAPTURE IN TO THE TARGET
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram
take a router transformation and pass the records through the router transformation and write the logic as if setvarcount()<=1 then send to one target and if setvarcount()>1 then rout them to second target then u can easily avoid duplicates and also u can verify them for future use. try this else correct me
| Is This Answer Correct ? | 0 Yes | 0 No |
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
what are the limitations of pushdown optimization technique ? Advance thanks
when informatica 8 series released ?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
What is a candidate key?
How to delete duplicate row using informatica?
What are the various types of transformation?
What do you mean by blocking transformation?
Performance tuning in UNIX for informatica mappings?
Write the program through which the records can be updated?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
Teradata 
