how to delete duplicate records by using filter
transfermation?

Answer Posted / devendar pd

if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.

I think we can't remove duplicates only by using filter

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dynamic target flat file name generation in informatica

639


How can we use mapping variables in informatica? Where do we use them?

613


How do you load only null records into target?

730


What are Dimensional table?

599


Write the unconnected lookup syntax and how to return more than one column.

589






what is the size of your data warehousing?

1665


How do you manage the Parameter files while migrating your data from one environment to another environment?

532


How to extract sap data using informatica? What is abap? What are idocs?

544


Explain the difference between a data warehouse and a data mart?

592


What is main use of mapplet?

648


what is index?how it can work in informatica

1572


What's the layout of parameter file (what does a parameter file contain?)?

1909


Plz can any one say me how to get the informatica certification materials and dumps

1589


While importing the relational source definition from the database, what are the metadata of source that will be imported?

778


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1224