How to extract original records at one target & Duplicate
records at one target?
Answer Posted / rag
Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is fact table? Explain the different kinds of facts.
Enlist some properties of sessions.
is it possible to index the data in cache of lkp transformation ?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Why filter transformation is an active one?
design of staging area?
Separate from a database, an information bazaar, and an information stockroom?
Why union transformation is an active transformation?
Explian the Process of deployment groups in informatica
What are the new features of informatica 9.x in developer level?
What is a sorter transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain the different lookup methods used in informatica?
What is a snowflake schema?