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?
Answer Posted / noothan
This is another option for implementing the same.
Implement a full outer join with File A as Left and File B
as right. Let the output contain Col_File_A from file A and
Col_File_B from file B. Pass this output through a filter
stage with the filter condition as below.
Col_File_B is null= file x
Col_File_B is not null and Col_File_A is not null = file Y
Col_File_A is null= file Z.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is difference between server jobs & parallel jobs?
What is the roundrobin collector?
What are the different layers in the information server architecture?
Explain ibm infosphere information server and highlight its main features?
What are the primary usages of datastage tool?
what is the use of materialized view?
What all are the different way to run a job?
What are iconv and oconv?
what is ds administrator used for?
What is "fatal error/rdbms code 3996" error?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How to convert RGB Value to Hexadecimal values in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
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
What is the difference between datastage and datastage tx?