In the transformer stage's link constraints: write below constraint

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 / subhash

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

Answer Posted / subhash

In the transformer stage's link constraints:
write below constraint
@INROWNUM <> 1 And @INROWNUM <> LastRow()
then you will get the desired out put.

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

2497

What are the functionalities of link collector?

1133

Define repository tables in datastage?

1200

Define Data Stage?

1139

Difference between data warehousing and olap?

1138

What are the functionalities of link partitioner and link collector?

1054

what is 'reconsideration error' and how can i respond to this error and how to debug this

2672

describe the Steps to confiure a Qlogic switch

2435

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

2412

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1462

Why do you need stage variables?

1229

On which interface you will be working as a developer?

1101

What are the types of views in datastage director?

1824

What a datastage macro?

1101

What is the difference between account and directory options ?

1232