how can u avoid duplicate rows in flat file?

Question Posted / radhakrishnansk

4 Answers
10725 Views
CTS, Wipro, I also Faced
E-Mail Answers

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

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers Amdocs,

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers

how can one eliminate dupliacte data with out using distinct option?

5 Answers Patni, Wipro,

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers

What is the maplet?

0 Answers Informatica,

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers Puma,

What is Cognos script editor?

0 Answers Cognizant,

How many types of sessions are there in informatica.please explain them?

0 Answers Informatica,

waht type of interface is used for testing the data in informatica

0 Answers CTS, TCS,

without table how to come first record only in oracle?

0 Answers

For more Informatica Interview Questions Click Here