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
- 7418 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 |
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
Name the different lookup cache(s)?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
Define update strategy?
if soource is having 10 records how will u insert 20 records to target
What is the session task and command task?
how will compare two mappings in two different repository?
in which situations do u go for scds ?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
what is incremantal aggregation?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
Teradata 
