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

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1612


Quickly characterize reusable change?

695


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

606


Clarify the utilization of aggregator cache record?

580


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

1554






What the difference is between a database, a data warehouse and a data mart?

599


Explain the tuning lookup transformation - informatica

615


Different circumstance which drives informatica server to expel records?

556


What are the tasks that can be performed using sq?

617


Sequence generator, when you move from develoment to production how will you reset

1413


Explain the aggregator transformation?

632


Enlist some properties of sessions.

636


What are roles and groups and benefits of using them?

574


What is transformation?

663


What is the benefit of partitioning a session?

635