1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

INPUT file 'A' contains:
1
2
3
4
5
6
7
8
9
10

input file 'B' contains:
6
7
8
9
10
11
12
13
14
15

Output file 'X' contains:
1
2
3
4
5

Output file 'Y' contains:
6
7
8
9
10

Output file 'Z' contains:
11
12
13
14
15

How can we implement this in a single ds job?

Question Posted / subbuchamala

Answers were Sorted based on User's Feedback



INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contai..

Answer / sarita

Hi Shar,
You aret hardcoding the values in your approach.I think the other approach could be:
1)Take a left outer join on the tables A and B. Common column for join can be a dummy=1.
2)Now output would be 2 columns one will have values 1,2,3,4,5,6,7,8,9,10 other will have NULL....NULL...6,7,...10
in expression transf...take a variable... chk when col a- col b != 0,then put flag X else Y
3)Then similarly do a join for B & C table and use same logic

Hope it works!

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

What is the process of killing a job in datastage?

0 Answers  

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,

What is the different type of jobs in datastage?

0 Answers  




What are the types of containers in datastage?

0 Answers  

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,

what is .dsx files

3 Answers   IBM,

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

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   IBM, PR3 Systems,

What is the difference between an operational datastage and a data warehouse?

0 Answers  

how to write server Routine coding?

0 Answers   Eric,

For more Data Stage Interview Questions Click Here
Categories