Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 12300 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / lb14447
The sql query would be
SELECT * FROM EMPTEST WHERE EMP_ID IN (SELECT EMP_ID FROM EMPTEST GROUP BY EMP_ID HAVING SUM(EMP_IND)/COUNT(EMP_IND) = 0
OR SUM(EMP_IND)/COUNT(EMP_IND) = 1);
Datastage implementation:
SRC --> CPY ----> AGG---> FILTER
- |
- |
- |
- |
- |
--------> Look up ----> TGT
In the Aggregator stage calculate the Sum and Count fields.In the filter stage bypass the unwanted records using Sum and Count calculated in Aggr stage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the features of datastage flow designer?
What are iconv and oconv?
What are data elements?
What is the difference between the local container and shared container?
Define APT_CONFIG in Datastage?
explain about citrix scheduling tool in datastage
What is size of a transaction and an array means in a datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How and where you used hash file?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is quality stage?
How do you generate sequence number in datastage?
What is the roundrobin collector?
