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
Name the third party tools that can be used in datastage?
what is the use of invokation id
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
Terminate Activity
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
how to remove duplicates in transformer stage by using stage variables?one example?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
How to Remove Duplicate using SQL?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help