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

Input is like
1
1
1
2
2
3
and out put should be 1
2
3
How can u acheive using rank transformation ??

Answer Posted / palthepu_santosh

from source qualifier map the column(id) into two fields of
rank (id,id_grp). select grp_id as group by and rank as 1
output should be
1
2
3

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is $$$$?

2202


How can informatica be used for an organization?

1274


Implementation methodology

1772


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250


What is mapping debugger?

1069


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2407


What is joiner transformation in informatica?

1100


How are indexes created after completing the load process?

1718


What do you understand by a term domain?

1173


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1711


How do we call shell scripts from informatica?

1191


what is the Default Source Option For Update Strategy Transformation?

1287


In development project what is the process to follow for an etl developer from day1

1758


How we can create indexes after completing the loan process?

1251