file having these input and we have to get 3 output using same job
Input
1
1
1
2
3
4
4
4
o/p1 o/p2 o/p3
1 1 2
2 1 3
3 1
4 4
4
What are the different plug-ins stages used in your projects?
What is the purpose of pivot stage?
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
whom do you report?
how to sort two columns in single job in datastage.
what is the main differences between Lookup, Join and Merge stages?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
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?
How to generate surrogate key without using surrogate key stage?
how to validate the jobs
How can we improve performance of data stage jobs?
What are routines in datastage?