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
- 9314 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
How and where you used hash file?
What is the roundrobin collector?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Can you explain tagbatch restructure operator?
What are iconv and oconv?
What is orabulk stage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the difference types of stages?
what is flow of project?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the functionalities of link partitioner?
Could anyone give brief explanation bout datastage admin
What a datastage macro?
What is the project in datastage?
Is possible to create skid in dim,fact tables?
