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 / huma

Answer Posted / huma

Why're we complicating the solution. Simple use merge stage. Output Y will be result of merge (inner join) while rest all will be the rejected outputs from update link.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is use Array size in datastage

1302

What is the sortmerge collector?

660

What are transforms and what is the differenece between routines and transforms?

611

Does datastage support slowly changing dimensions ?

659

What is usage analysis in datastage?

810




Name the third party tools that can be used in datastage?

611

How can we improve performance of data stage jobs?

612

What are the processing stages?

640

How the ipc stage work?

670

Difference between server jobs & parallel jobs?

648

How to Remove Duplicate using SQL?

842

What is a ds designer?

640

What is the process of killing a job in datastage?

588

AGGREGATOR default datatype

931

What are orabulk and bcp stages?

645