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
11259 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 type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers CGI,

how we load the data from source to staging area

4 Answers TCS,

In a table, 4 person having same salary. How to get Third person record only?

15 Answers

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers TCS,

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers Accenture,

What are active and passive transformations?

0 Answers Informatica,

What is the session task and command task?

0 Answers

How to load query faster,so that It will take less time to load?

1 Answers BNP Paribas,

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers DELL, iGate,

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers TCS,

What do you mean by filter transformation?

0 Answers

What is the scenario which compels informatica server to reject files?

0 Answers

For more Informatica Interview Questions Click Here