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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a folder? Difference types of stages?

845


Can you explain repository tables in datastage?

1145


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

587


Where the datastage stored his repository?

789


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1669


what are the errors,warnings in datastage

2390


What are the functionalities of link partitioner?

809


What is merge stage?

972


Name the different sorting methods in datastage.

808


Differentiate between odbc and drs stage?

807


Describe link sort?

816


How a routine is called in datastage job?

822


What are the partitioning techniques available in link partitioner?

2025


What is the difference between datastage and informatica?

845


What is the difference between passive stage and active stage?

1076