How to delete duplicate records in a flat file source?

Answer Posted / bsgsr

conncet the flat file to sorter transformation and select
distinct option.

Is This Answer Correct ?    17 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a non-reusable instance of reusable transformations?

685


In warehouses how many schemas are there?

584


What is dynamic cache?

614


r u done any partitions in ur project?

1407


What are the differences between a connected lookup and unconnected lookup?

654






What is the need for an etl tool?

640


On which transformations you created partitions in your project?

763


When do you use sql override in a lookup transformation?

590


How can you increase the performance in joiner transformation?

713


What are the limitations of joiner transformation?

657


Tell me about MD5 functions in informatica

528


Explain joiner transformation in informatica

670


Why union transformation is an active transformation?

659


What is informatica worklet?

612


What is the sql query overwrite in source qualifier in informatica

619