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

My source table having some records ,i want load 1st record
and last record into one target?

Answer Posted / kiran

take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate row using informatica?

1086


What are the types of presistent cache in look up tr.

2104


Enlist the differences between database and data warehouse.

1164


explan ur project architecture?

2126


complex mapping ur project u r invlve can u explain and give real time example give me ?

2346


How many input parameters can exist in an unconnected lookup?

1599


Plz can any one say me how to get the informatica certification materials and dumps

2097


what are factless facts? And in which scenario will you use such kinds of fact tables.

1855


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1137


differences between service based and product based?

2058


Differentiate between router and filter transformation?

1063


What does refresh system mean, and what are its distinctive choice?

1269


How to generate sequence numbers without using the sequence generator transformation?

1252


How can informatica be used for an organization?

1271


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2441