Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7230 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
What are the different layers in the information server architecture?
Where the datastage stored his repository?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
In Datastage, how you can fix the truncated data error?
How a routine is called in datastage job?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to add a new records into source?
What are the types of views in datastage director?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is the command line function to import and export the ds jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Explain entity, attribute and relationship in datastage?
How and where you used hash file?
What are the various kinds of the hash file?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
