Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / manojkumar.challagundla

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

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

how to get the first row without using rank t/r?

7 Answers   iGate,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

What do you mean by filter transformation?

0 Answers  

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

What is a command that used to run a batch?

4 Answers  

What are reusable transformations in how many ways we can create them?

2 Answers  

How do you migrate data from one environment to another?

0 Answers  

What is DTM process?

4 Answers  

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

For more Informatica Interview Questions Click Here
Categories