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
7351 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 you Implemented SCD Type 1 & Type 2 in your project?

4130

What is active and passive stage?

1414

whom do you report?

1935

how to abort the job its matain duplicates?

2575

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

1240

What is a quality stage in datastage tool?

1079

What is staging variable?

1099

How to manage date conversion in Datastage?

1139

Give an idea of system variables.

1037

Define Data Stage?

1097

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

Can you implement SCD2 using join, transformer and funnel stage?

1558

What a datastage macro?

1064

What are the different common services in datastage?

1288

What is oci?

1304