how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14439 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 |
What is rank transform?
In which circumstances that informatica server creates Reject files?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Can we use the mapping parameters or variables created in one mapping into another mapping?
what is the difference between static and dynamic
What is informatica? What exactly are the practical uses in real world
What is data caches/ index caches?
Two different admin users created for repository are ______ and_______
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
What is the benefit of session partitioning?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Teradata 
