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 to load only the first and last record of a flat file
into the target?

Answer Posted / ram pothineni

Create a port in Expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
the records. Create 2 condition in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row). Connect both to target. Dont forget to give reset
option in SEQ generator.


http://it.toolbox.com/people/raambabuchowdary/

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create a node as a gateway node and the same node can be assigned to a grid?

1125


State the differences between sql override and lookup override?

1283


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2112


what are the Methods For Creating Reusable Transformations?

1253


In warehouses how many schemas are there?

1128


What are junk dimensions?

1111


What are the components of the workflow manager?

1179


update strategy transformation in informatica

1122


4 yrs etl devloper roles and responsibilities?any body give solutions

2245


What is status code in informatica?

1063


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

1140


What is rank transformation in informatica

1231


What are the main features of Oracle 8i with context to datawarehouse?

2159


Can we change Dynamic to Static or Persistent cache? If so what happens?

2249


What are the different components of powercenter?

1112