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
- 7265 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
How a server job can be converted to a parallel job?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the partitioning techniques available in link partitioner?
What is the difference between odbc and drs stage?
How can we improve the performance in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Difference between server jobs & parallel jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the use of datastage director?
Name the command line functions to import and export the DS jobs?
What is the difference between validated and compiled in the datastage?
What are the components of datastage?
What is use Array size in datastage
