how can u avoid duplicate rows in flat file?

Question Posted / radhakrishnansk

4 Answers
10571 Views
CTS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can u avoid duplicate rows in flat file?..

Answer / sunil

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

Is This Answer Correct ?

11 Yes

0 No

how can u avoid duplicate rows in flat file?..

Answer / radhakrishnansk

sorted transformation

Is This Answer Correct ?

6 Yes

1 No

how can u avoid duplicate rows in flat file?..

Answer / ramanaiah

without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.

Is This Answer Correct ?

3 Yes

1 No

how can u avoid duplicate rows in flat file?..

Answer / sbvp

i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata

1 Answers Cognizant,

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers iGate,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers Zensar,

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers

How to generate sequence numbers?

0 Answers

What is meant by pre and post session shell command?

0 Answers

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers TCS,

What are active and passive transformations?

0 Answers Informatica,

What is Performance tuning in Informatica?