How do you avoid duplicate records with out using source qualifier,expression,

How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?

Question Posted / manojkumar.challagundla

4 Answers
10926 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / triveni

rank transformation
ex: empno,ename
1,ramu
1,ramu
2,rani
2 ,rani

empno(group by),ename(returnport) top1 or bottom1

target: 1 ramu
2 rani

Is This Answer Correct ?

14 Yes

0 No

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / prasad

u can use unix command in pre session as sort -u file1
>newfile

Is This Answer Correct ?

8 Yes

3 No

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / manoj kumar

Good logic.

Thank you

Is This Answer Correct ?

1 Yes

0 No

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter an..

Answer / manojkumar

Thank you prasad.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Informatica Interview Questions

How to improve the performance of Aggregate transformation?

3 Answers Dmss,

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers

How do you do error handling in Informatica?

1 Answers

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers TCS,

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers

How do we call shell scripts from informatica?

0 Answers

What is an expression transformation?

0 Answers

What is primary and backup node?

0 Answers

what is surrogate id ?

3 Answers IBM,

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers Accenture,

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers BirlaSoft,

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers CTS, HCL, Infosys, TCS,

For more Informatica Interview Questions Click Here