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.
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
Why fact table is in normal form?
What are the steps needed to create a simple basic datastage job?
What are the some differences between 7.x and 8.x version of datastage?
What is a merge?
Define data aggregation?
What are stage variables?
client know skid info?
How one source columns or rows to be loaded in to two different tables?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the difference between Datastage 7.5 and 7.0?
What is ibm datastage flow designer?
What are the types of views in datastage director?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
which r the connectors used in san?
What is the process of killing a job in datastage?