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

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Answer Posted / rajesh

Use head and tail command(Pre session command) write it into two files.Use transformation to read that files as per your requirement

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create two repositories on same database instance in oracle?

1018


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1578


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1088


what is diff b/t sorter t/r and agg have the option sorter property...

2133


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9979


What is a grid in Informatica?

1003


Why update strategy and union transformations are active?

991


What is the difference between router and filter?

1155


What are connected or unconnected transformations?

1051


How identifying bottlenecks in various components of informatica and resolving them?

1057


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1011


Is there any way to read the ms excel datas directly into informatica?

980


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2096


What is rank index in rank transformation?

1013


What is source qualifier transformation in informatica?

950