1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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 the use of materialized view?

958

What are routines in datastage? Enlist various types of routines.

627

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1927

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1896

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1040




Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3756

What is a merge in datastage?

765

What are the processing stages?

640

What is a ds designer?

640

How one source columns or rows to be loaded in to two different tables?

659

What is the difference between datastage and datastage tx?

590

What is the use of datastage director?

586

How many areas for files does datastage have?

640

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

972

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

963