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

Informatica and datawarehousing courses in Pune?

2 Answers  


My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  


How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,


What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,


What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,


Do joiner transformation use cache? If so describe?

2 Answers   Patni,


What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,


I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  


Categories