Hi guys,
please design a job with derivation(solution).
write exact conditions.
My requirement
Source table
emp_no qualification
1 a
1 c
2 a
3 c
3 b
Target table
emp_no qualification
1 b
2 b
2 c
3 a
Here every employer have three qualifications i.e a,b and c.
what ever source table dont have some qualification, that
will be move to target table.
Like above.
Hope u get the point.
Thanks.
- 4 Answers
- 9363 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / sher
A) Read distinct emp_no we get 1,2,3 add a new column and populate as 1
B) read qualification, we get a,b,c add add a new column and populate as 1
Inner join A and B on new column…
we get 1-A,1-B,1-C 2-A,2-B,2-C and 3-A,3-B,3-C
Change capture with input file and drop all records with no change.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the steps needed to create a simple basic datastage job?
What are iconv and oconv?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How complex jobs are implemented in datstage to improve performance?
What are transforms and what is the differenece between routines and transforms?
How can one find bugs in job sequence?
What are some different alternative commands associated with "dsjob"?
How do you run datastage job from the command line?
Explain ibm infosphere information server and highlight its main features?
How do you start developing a datastage project?
Highlight the main features of datastage?
Define data aggregation?
How we can covert server job to a parallel job?
what is flow of project?
