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
- 9347 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / shar
Since Each Employee should have 3 qualification then Primary
file should be like below because Primary is always Static.
In which terms it should be like this.
Primary file:
empno,qua
1,a
1,b
1,c
2,a
2,b
2,c
3,a
3,b
3,c
And this is our Reference data we have.
RefFile:
empno,qua
1,a
1,c
2,a
3,c
3,b
Primary,ref-->lookup-->output & Reject.
and match the empno and qua and set lookup failue = reject
at reject file
U will get desired output.
Thats it.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Differentiate between operational datastage (ods) and data warehouse?
what is the use of materialized view?
What is the purpose of pivot stage?
how to delete one row in target dataset
Nls stands for what in datastage?
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?
How you Implemented SCD Type 1 & Type 2 in your project?
What are transforms and what is the differenece between routines and transforms?
What are constraints and derivations?
What are the functionalities of link collector?
What is difference between symmetric multiprocessing and massive parallel processing?
How one source columns or rows to be loaded in to two different tables?
What are the important features of datastage?
What is datastage engine?
How to RD using transformer?
