Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10766 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
which r the connectors used in san?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Describe link sort?
Distinguish between informatica & datastage. Which one would you choose and why?
Differentiate between datastage and datastage tx?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Differentiate between Join, Merge and Lookup stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Nls stands for what in datastage?
Name the different types of Lookups in Datastage?
What all the types of jobs you developed?
What are the steps needed to create a simple basic datastage job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
To see hidden files in LINIX?
What are the areas of application?
