SRC--SRT---FLT---| | LKP CPY---| |

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

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

Answer Posted / mahalakshmi

SRC--SRT---FLT---|
| LKP
CPY---| |
| |
|__FNL_|
|
TGT
1.In Sort Stage (Keys on Empid & Emp Ind), Create Key
changeColumn = True
2. In Filter WhereClause-(Keychange=0)OutputLink=0
WhereClause-(Keychange=1)OutputLink=1
3.In Lookup InnerJoin on EmpId
4.In Funnel, Funnel Type=Sorted Funnel

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you schedule or monitoring the job?

1266

What is the difference between account and directory options ?

1233

What are routines in datastage? Enlist various types of routines.

1153

Why fact table is in normal form?

1307

CHANGE CAPTURE

1352

How do u convert the columns to rows in datastage?

1243

Can you filter data in hashed file?

3825

Explain the importance of surrogate key in data warehousing?

1232

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

855

Triggers,VIEW,Procedures

1263

What is the precedence of stage variables,derivations, and constraints?

1126

Explain connectivity between datastage with datasources?

1040

State the difference between an operational datastage and a data warehouse?

1179

What is quality stage?

1043

What is the difference between server job and parallel jobs?

1198