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

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about cumulative Sum or moving sum?

999


How to go to the older version for a mapping?

1050


How to handle decimal places while importing a flatfile into informatica?

1157


What does reusable transformation mean?

1096


What all join we can perform in LOOKUP transformation?

936


tell me the rules and responsblites in our project(my project is development)

1905


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2245


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1898


What is Index Caches size?

1082


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1742


explain abt ur project architecture?

2148


How to join three sources using joiner?

1060


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

1029


How to load the data from a flat file into the target where the source flat file name changes daily?

1029


my source is junk data how will u remove that junk data by using unix please any one replay me

3666