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 / vinod saini

After sql Trans use AGG,JOINER transformation,and use FIRST
& LAST function in AGG transformation without any group.
FIRST & LAST return the first & Last record values. give
JOINER condition based on first & last.

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sorter transformation?

993


define galaxy repository in informatica

2170


How many input parameters can exist in an unconnected lookup?

1511


How can you differentiate between powercenter and power map?

1030


What are the new features of informatica 9.x in developer level?

948


What is joiner transformation in informatica?

1000


How to do unit testing in informatica?

1133


Explain the difference between mapping parameter and mapping variable?

994


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

1880


What all are steps in up gradation of Informatica server?

1005


What are pre and post-session shell commands?

1251


what are 3 tech challenges/ common issues you face?

2291


What is Cognos script editor?

4178


Can we get 1st record through Informatica(without sequence number).

1423


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1019