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 a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


How to improve the session performance in informatica?

3 Answers   Accenture,


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


why we are using level option in normalizer transformation

0 Answers   TCS, Wells Fargo,


Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  






How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,


In joiner, how to load Master table in Target?

2 Answers  


What are the rank caches?

2 Answers   Informatica,


how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   HP, Cognizant, TCS,


Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  






Categories