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
- 9321 Views
- UHG, I also Faced
- E-Mail Answers
Answer Posted / sriharsha vemuri
Take source as emp_no,qualification 1,b 2,b 2,c 3,a and
reference as date as emp_no,qualification 1,a 1,b 1,c 2,a
2,b 2,c3,a3,c 3,b now take lookup for both
emp_no,qualification columns and reject the date. This Worked.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
What are datastage sequences?
Explain the situation where you have applied SCD in your project?
whom do you report?
How to perform incremental load in datastage?
How to reverse the string using SQL?
client know skid info?
Which warehouse using in your datawarehouse
what is flow of project?
What are stage variables and constants?
Can you explain tagbatch restructure operator?
What are system variables and sequencers in datastage
What are the primary usages of datastage tool?
I have a few records just I want to store data in to targets cycling way how?
What is the difference between orabulk and bcp stages?
