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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

What are the different plug-ins stages used in your projects?

0 Answers  


What is the purpose of pivot stage?

0 Answers  


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

0 Answers  


whom do you report?

0 Answers   NTT Data,


how to sort two columns in single job in datastage.

1 Answers   TCS,


what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,


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

1 Answers  


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   TCS,


How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,


how to validate the jobs

2 Answers   IBM,


How can we improve performance of data stage jobs?

0 Answers  


What are routines in datastage?

0 Answers  


Categories