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 can we load first and last record from a flat file
source to target?

Answer Posted / hina

Below transformation would work: Add the Nextval port of the sequence generator to both the Rank Transformations. In rank transformation select Top and Bottom resp.
------ Rank Transformation (Top)----Tgt(Ins1)
|
SQ---Sequence Generator-----
|
-------Rank Transformation(Bottom)-Tgt(Ins2)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you manage the Parameter files while migrating your data from one environment to another environment?

961


Explain sql transformation in script mode examples in informatica

1043


Where do we use mapping variables in informatica?

995


What are the different ways to implement parallel processing in informatica?

1339


How to Create a folder using pmrep command?

1101


whats the logic to load the lower level of granularity of data to fact table.

2205


What are the modules in Power Center

1621


What does update strategy mean, and what are the different option of it?

1034


What is the need for an etl tool?

1009


What is the different lookup cache(s)?

1031


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

2004


define galaxy repository in informatica

2153


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

1864


What is data caches/ index caches?

1017


tell me 5 session failure in real time how can you solve that in your project?

2182