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
- 12335 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
What are the partitioning techniques available in link partitioner?
Can you explain kafka connector?
Why do we use link partitioner and link collector in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the difference between server job and parallel jobs?
Can you highlight the main features of ibm infosphere information server?
What are the functionalities of link collector?
What is the difference between an operational datastage and a data warehouse?
Can you implement SCD2 using join, transformer and funnel stage?
Name the different sorting methods in datastage.
What is the difference between passive stage and active stage?
On which interface you will be working as a developer?
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 processing stages?
What are the different layers in the information server architecture?
