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

Can we create multiple integration service on single repository?

1182

without table how to come first record only in oracle?

2247

if we have a delimiters at unwanted places in a flat file how can we over come those.

2043

What is confirmed fact in dataware housing?

6955

Mention few advantages of router transformation over filter transformation.

1019

What is meant by incremental aggregation?

1096

Do you find any difficulty while working with flat files as source and target?

1092

In how many ways we can create ports?

1116

Plz can any one say me how to get the informatica certification materials and dumps

2042

What is an aggregator transformation?

1096

Explain the types of transformations?

1058

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2172

Explain constraint based loading in informatica

1087

Have you worked with/created Parameter file

1658

What is persistent lookup cache?

1026