If data is fetching from SeqFile, we can do this way also Use Filter Com

Hi All, I have a file. i need to fetch the records between
first and last records by using transform stage.

EX:-

Source:
EMPNO EMPNAME
4567 shree
6999 Ram
3265 Venkat
2655 Abhi
3665 Vamsi
5852 Amit
3256 Sagar
3265 Vishnu

Target:

EMPNO EMPNAME
6999 Ram
3265 Venkat
2655 Abhi
3665 Vamsi
5852 Amit
3256 Sagar

I dont wan't to Shree and vishnu records.we can fetch
another way also but How can I write the function in
transform stage?

Question Posted / reddymkl.dwh

2 Answers
7251 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / reddymkl.dwh

If data is fetching from SeqFile, we can do this way also

Use Filter Command

Sed '1d;$d' FileName
It will delete frist and last records.

U will get answer, Plz correct me if am wrong....

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you reject records in a transformer?

1069

What are the main differences you have observed between 7.x and 8.x version of datastage?

1034

how to write server Routine coding?

2074

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2054

What is merge stage?

1238

What are the steps required to kill the job in Datastage?

1164

What is the roundrobin collector?

1051

What are the types of containers and how to create them?

945

What is difference between join, merge and lookup stage?

1051

Explain how a source file is populated?

1326

How do y read Sequential file from job control?

15832

What are the steps needed to create a simple basic datastage job?

1176

Triggers,VIEW,Procedures

1186

What is process model?

1930

in oracle target stage when we use load option and when we use upsert option?

2214