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
7339 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

What is difference between server jobs & parallel jobs?

1032

What is a folder? Difference types of stages?

1167

To see hidden files in LINIX?

1520

What is the use of datastage director?

1012

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3342

Define project in datastage?

1089

What is ds designer?

1095

What are the areas of application?

1142

How we can covert server job to a parallel job?

1136

How to convert RGB Value to Hexadecimal values in datastage?

3990

What are the different options associated with dsjob command?

1427

How and where you used hash file?

1167

What are constraints and derivations?

1164

What is oci?

1297

How do y read Sequential file from job control?

15945