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
- 7357 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
root tree will find which is server job and which is parallel job?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the process of killing a job in datastage?
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
how to export or import the jobs in .ISX file
Why do you need stage variables?
What is the differentiate between data file and descriptor file?
How many types of stage?
What is the difference between validated and compiled in the datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Differentiate between data file and descriptor file?
What is ibm datastage flow designer?
Define data aggregation?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the stages in datastage?
