Interested to Buy Any Domain ? << Click Here >> for more details...
Input file one has data as shown below
1
2
3
4
5
6
7
8
Input file two has data like
6
7
8
9
10
11
Design a data stage job which will provide me three output files as shown below:
Output 1
6
7
8
Output 2
1
2
3
4
5
Output 3
9
10
11
Let me know your answers
- 4 Answers
- 6408 Views
- IBM, PR3 Systems, I also Faced
- E-Mail Answers
Answer Posted / pavani
by using join type=full outer.we have to get output has 2 columns. 1st_column values are first inputs and remaining nulls,2_column values are second input and remaining are nulls.
then by using transformer write a constraint
1.output----->1st_column=2_column;
2.output----->2_column=null or'';(depending on input data)
3.output----->1st_column=null or'';(depending on data)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is possible to create skid in dim,fact tables?
What is a quality stage in datastage tool?
What are the differences between datastage and informatica?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are orabulk and bcp stages?
Explain datastage architecture?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to export or import the jobs in .ISX file
Can you explain engine tier in information server?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to sort two columns in single job in datastage.
how many rows sorted in sort stage by default in server jobs
What is meta stage?
