Interested to Buy Any Domain ? << Click Here >> for more details...
how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 15025 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 the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
Explain the use of aggregator cache file?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
can we override a native sql query within informatica? How do we do it?
What is a parameter When and where do you them when does the value will be created
What is the difference between bitmap and btree index?
Sequence generator, when you move from develoment to production how will you reset
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
hi real timers . iam waiting for ur reply regarding ETL TESTING
Mention some types of transformation?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Quickly characterize reusable change?
Teradata 
