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
- 9660 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 is the difference between datastage and informatica?
What are the repository tables in datastage?
What is ibm datastage flow designer?
How will you move hashed file from one location to another location?
whom do you report?
What is a folder? Difference types of stages?
sed,awk,head
Differentiate between validated and Compiled in the Datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
How to convert RGB Value to Hexadecimal values in datastage?
Is possible to create skid in dim,fact tables?
how can we create rank using datastage?what is the meaning of rank?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Can you define merge?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
