Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what is semi-additive fact?where did u used?

2 Answers  

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

how do u move the code from development to production?

6 Answers  

What are the join types in joiner transformation?

1 Answers   Informatica,

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

What is a design?

1 Answers  

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

What is difference between maplet and reusable transformation?

2 Answers  

For more Informatica Interview Questions Click Here
Categories