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
Answer Posted / 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 |
Post New Answer View All Answers
What is persistent lookup cache?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain incremental aggregation in informatica
Explain Dataware house architecture .how data flow from intial to end?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explian the Process of deployment groups in informatica
Performance tuning in UNIX for informatica mappings?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How can we store previous session logs?
What is session task and command task?
if we have a delimiters at unwanted places in a flat file how can we over come those.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is meant by incremental aggregation?