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

Answer Posted / tanay

You can use Head and Tail commands in UNIX to achieve the
same. Please correct me if i am wrong.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Pmrep command?

642


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

554


As union transformation gives UNION ALL output, how you will get the UNION output?

653


What do you mean by filter transformation?

557


Under what condition selecting sorted input in aggregator may fail the session?

669






Partition, what happens if the specified key range is shorter and longer

2031


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1792


What are Dimensional table?

622


What are the main issues while working with flat files as source and as targets ?

660


Explain the features of connected and unconnected lookup.

548


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

545


Does an informatica transformation support only aggregate expressions?

612


In development project what is the process to follow for an etl developer from day1

1286


Define the various join types of joiner transformation?

561


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1625