How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

Answer Posted / sam

In sequential file stage, properties tab --- options -- filter

At filter type unix command -- sed '1d;$d'

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between == and eq in UNIX shell scripting?

970


What is use Array size in datastage

1300


What is process model?

1549


Differentiate between data file and descriptor file?

615


Why fact table is in normal form?

666






i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2268


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1801


Different ways a project can be moved to production ?...example ….export-import and Version control.

1927


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2050


CHANGE CAPTURE

887


Notification Activity

893


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2837


What are the important features of datastage?

614


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1743


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2985