In DataStage: SRC--->CPY---->JOIN----TFM---TGT --------|---- / ---

Input Data is:
Emp_Id, EmpInd
100, 0
100, 0
100, 0
101, 1
101, 1
102, 0
102, 0
102, 1
103, 1
103, 1
I want Output
100, 0
100, 0
100, 0
101, 1
101, 1
Means Indicator should either all ZEROs or all ONEs per
EmpId.
Impliment this using SQL and DataStage both.

Question Posted / subhash

6 Answers
12072 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / subhash

In DataStage:
SRC--->CPY---->JOIN----TFM---TGT
--------|---- /
--------|--- /
--------|-- /
--------|- /
--------AGG
In AGG, GROUP BY EmpId, calculate MIN and MAX for each
EmpId.
JOIN both one copy from CPY and 2nd Aggrigated copy from
AGG.
In TFM, put constraint: IF MIN=MAX, then populate to TGT
then u will get required output.

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe routines in datastage? Enlist various types of routines.

954

What is oci?

1259

What is a quality stage in datastage tool?

1025

What are the repository tables in datastage?

1258

Define project in datastage?

1052

Difference between server jobs & parallel jobs?

1015

What is a datastage job?

965

What is active and passive stage?

1360

What are the types of containers?

1142

Why we use surrogate key?

1159

What is apt_config in datastage?

1084

What are iconv and oconv?

1182

What is orabulk stage?

992

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3736

What is ds designer?

1030