how can u avoid duplicate rows in flat file?

Answer Posted / sunil

In a sorter transformation select distinct option to avoid
duplicates in a flat file

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

552


what is the difference between informatica6.1 and infomatica7.1

1711


What is mapping debugger?

568


What is the format of informatica objects in a repository?

593


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1627






What is xml source qualifier transformation in informatica?

709


What are the different versions of informatica?

672


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

553


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1730


What is informatica powercenter repository?

708


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1614


What are the components of workflow manager?

584


Partition, what happens if the specified key range is shorter and longer

2028


How can you increase the performance in joiner transformation?

704


How to load last n records of file into target table - informatica

593