how will you remove the duplicate records from flat file
without using sorter?

Answer Posted / rkumar.etl

use aggregator transformation and group by all ports and
create one port for checking count...and pass the results
accordingly to target tables.

Is This Answer Correct ?    24 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is option by which we can run all the sessions in a batch simultaneously?

652


What are the new features of informatica 9.x developer?

524


How to update source definition?

619


Explain lookup transformation in informatica

636


Tell me about MD5 functions in informatica

511






What is meant by pre and post session shell command?

610


How to improve the performance of a session using sorter transformation?

677


 Informatica Checkpoints

2846


Explain direct and indirect flat file loading (source file type) - informatica

809


What are mapplets?

804


difference between informatica 8.1.1 and 8.6

3230


How do we call shell scripts from informatica?

583


How can informatica be used for an organization?

638


Define joiner transformation?

582


Which means the first record should come as last record and last record should come as first record and load into the target file?

599