Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 18256 Views
- CTS, I also Faced
- E-Mail Answers
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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Whats difference betweeen operational data stage (ods) and data warehouse?
Describe stream connector?
what is the use of materialized view?
What is active and passive stage?
options available in sequence job to run,validate?
which r the connectors used in san?
What is the purpose of pivot stage and types of containers in datastage
describe the Steps to confiure a Qlogic switch
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the various kinds of containers available in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How do you run datastage job from the command line?
What are the primary usages of datastage tool?
why do u need the IOS upgradation in a FC switch
