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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / sathish

use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates

Is This Answer Correct ?    5 Yes 2 No

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

Answer / ajit kumar pradhan

if it is a relational source then click on source Qualifier
properties then check Distinct option.

if it is a flat file then it can't work .......

click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...

Is This Answer Correct ?    0 Yes 0 No

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

Answer / sathish

put primary key to target it will reject duplicate rows

Is This Answer Correct ?    1 Yes 4 No

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

Answer / suren

by setting option distinct option

Is This Answer Correct ?    2 Yes 5 No

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

Answer / amedela chandra sekhar

SD---S.Q----EXP t/r------TGT.

add two port in exp t/r.
one is variable port v_seq expression:seq+1
one output port o_seq expression:v_seq
required ports connect to target.

Is This Answer Correct ?    1 Yes 4 No

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

Answer / krishnakanthch

We can use the option 'SELECT DISTINCT' in the source
qualifier.

Anybody please tell me whether this works or not.

Is This Answer Correct ?    5 Yes 23 No

Post New Answer

More Informatica Interview Questions

How to open an older version of an object in the workspace?

0 Answers  


What is the need of etl tools?

0 Answers  


What is Index Caches size?

0 Answers   Informatica,


What is facttable granularity?

2 Answers  


Why sorter is an active transformation?

0 Answers   Informatica,






why we use informatica in our project?

2 Answers   TCS,


What is data movement mode in Informatica and difference between them?

0 Answers  


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


How can you generate reports in informatica?

0 Answers  


What is the benefit of session partitioning?

0 Answers  


Types of error logs in Informatica?

2 Answers  


Why do we use DSS database for OLAP tools?

2 Answers  


Categories