we can write the shell script for it head -1 tail -1 we call it either i

how to load only the first and last record of a flat file
into the target?

Question Posted / ghouse

Answer Posted / ghouse

we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session
shell commands in seession

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to Create a folder using pmrep command?

626

Why do we need informatica?

562

How an expression transformation differs from aggregator transformation?

632

What is the difference between router and filter?

652

What are the differences between oltp and olap?

556

What is the difference between STOP and ABORT options in Workflow Monitor?

703

Explain the etl program with few examples.

552

Explain where to store informatica rejected data? How to extract the informatica rejected data?

584

How to do unit testing in informatica? How to load data in informatica ?

655

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

786

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

602

How can you validate all mappings in the repository simultaneously?

764

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1545

Target increases every day even though no new record was inserted

1113

can you please explain me pre session and post session options?

6395