I have a source like file it have Number of records and i want to load without f

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

Question Posted / rameshkumar.boddu

4 Answers
15858 Views
CSC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a source like file it have Number of records and i want to load without first and last record..

Answer / shivam

For this we can use Head and tail stages from development
and debug stages. Suppose we have 10 records,And we are
asked to pick 2nd to 9th record in the output, then go for
the following:
Sequential file--->Head stage--->Tail stage---->Data set

In the Head stage properties mention the number of records
you want to extract 9 records, this way you will get 1st to
9th records(top 9) extracted. Now, in Tail stage properties
mention number of records to extract 8, this way you get
last 8 records out of top 9 i.e 2nd to 9th. Finally as an
output you will find records 1st and 10th dropped.

Is This Answer Correct ?

7 Yes

1 No

I have a source like file it have Number of records and i want to load without first and last record..

Answer / prasad

In seq file, we have filter option (datastage)

filter= sed '1d;$d'

In Unix= sed '1d;$d' File_Name

it will remove header and footer records(quotes must and should)

Is This Answer Correct ?

3 Yes

0 No

I have a source like file it have Number of records and i want to load without first and last record..

Answer / srinu

using external filter
in this we use command sed -n '1d,
$d'(this is unix command we use we get answer)
(or)
we use command tail +2 |sed -n '$d'

Is This Answer Correct ?

6 Yes

4 No

I have a source like file it have Number of records and i want to load without first and last record..

Answer / prabhu

we use seq file
in that stage properties->options->filter in that SED'2,$!P' FILENMAE
IT ISWORKING

Is This Answer Correct ?

0 Yes

2 No

Post New Answer