Interested to Buy Any Domain ? << Click Here >> for more details...
how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 15022 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Briefly describe lookup transformation?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Discuss the advantages & Disadvantages of star & snowflake schema?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is mapplet and a reusable transformation?
How to improve the session performance in informatica?
Informatica and datawarehousing courses in Pune?
Explain the scenario which compels informatica server to reject files?
What is meant by pre and post session shell command?
What are the differences between joiner transformation and source qualifier transformation?
Teradata 
