Interested to Buy Any Domain ? << Click Here >> for more details...
how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14872 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju bhatraju
1.)
we can distinguish between unique and duplicate records in
informatica by using forward reference technique ,
in the sense , we can store the previous rec key value in
Variable_Port and can be compared with the previous rec key
value , but Data has to be come in sorted order on that key
column , for that we should use sorter transformation.
once if you find the duplicate rec by comparing , you can
flag that rec as dulicate and you can divert it to other
target.
2.) with out using sorter
in order to collect only unique records for flat file ,
just use aggregator before exp transformation, and check
group by on the key column where you are expecting
duplicate records. so you will get only unique records and
duplicate records will be eliminated.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target?
Is there any target staging area in informatica not staging area
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain in detail about scd type 1 through mapping.
What is workflow? What are the components of workflow manager?
What are active transformations.
What is rank transformation in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
tell me about your project functionality
What is a snowflake schema?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the modules in Power Center
What are the differences between source qualifier and joiner transformation?
What is union transformation in informatica?
How can we handle two sessions in informatica?
