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 22 No

Post New Answer



More Informatica Interview Questions

what is diff between grep and find

3 Answers   IBM, iFlex,


Do you have knowledge in ralph kimball methodology

1 Answers  


what is the exact meaning of domain?

2 Answers  


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


what is parallel querying and what r hints.

1 Answers  






If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,


Can you copy the batches?

3 Answers  


What is DTM process?

4 Answers  


comonly how meny mappings r there in Banking projects?

1 Answers  


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   IBM, Cap Gemini,


What is the Router transformation?

2 Answers   Informatica,


what is the process of target load planing?

2 Answers   IBM,






Categories