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
Answers were Sorted based on User's Feedback
seq file1 and file2 as input to change capture stage and then a switch stage with case=0,1,2 (on change code). Case=0 will give 6,7,8. Case=1 will give 1,2,3,4,5 and case=2 will give you 9,10,11
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suresh
Actually we observe 1st output has common numbers of two inputs,remaining outputs have indiaviduals wrt to input data.
Suppose we validate the application using equivalence partitioning using this approach.
Same as we validate boundary value wrt two inputs can approach this one.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Use input file1 as after file and input file2 as before file to a change capture stage. Change capture stage generates change code 0 for 6,7,8 & 1 for 1,2,3,4,5 and 2 for 9,10,11. Use a filter/switch stage after change capture stage to write records to output file1 when change code is 0, to output file2 when change code is 1 and to output file3 when change code is 2.
Is This Answer Correct ? | 0 Yes | 2 No |
Have you used Unstructured data?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
what is the main difference between sorragate key n primary key in one word
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
what about data stage requirement
difference between function and procedure...
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
What is the difference between an operational datastage and a data warehouse?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Describe the main features of datastage?