how can u avoid duplicate rows in flat file?

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

What are the components of workflow manager?

0 Answers  


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


can you use flat file for lookup table?why?

2 Answers   HCL,


Write the different tools in the workflow manager?

0 Answers  


Explain one complecated mapping?

3 Answers   Fidelity, Wipro,


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


WAT IS TEXT LOAD?

3 Answers   Wipro,


What does role playing dimension mean?

0 Answers  


What is mapplet in informatica?

0 Answers  


Explain why we use partitioning the session in informatica?

0 Answers  


What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


Categories