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
10966 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

What are the advantages of informatica?

0 Answers

Define the various join types of joiner transformation?

0 Answers

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers Wipro,

Write the program through which the records can be updated?

0 Answers

what is target load plan

2 Answers Cap Gemini,

What is workflow monitor?

0 Answers

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers

why dimenstion tables are denormalized in nature ?

3 Answers

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers CTS,

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,

Where do we use mapping variables in informatica?

0 Answers

How will the document be delivered to me?

0 Answers

For more Informatica Interview Questions Click Here