how to duplicates from expression transformation without
using sorter before that
- 1 Answers
- 14580 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 difference between Power Centre and Power Mart?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
if we have a delimiters at unwanted places in a flat file how can we over come those.
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are junk dimensions?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
why do u use shortcuts in informatica.?
Describe expression transformation?
how DTM buffer size and buffer block size are related
Differentiate between sessions and batches?
Teradata 
