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
- 10561 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
On which Dimension Table you implemented SCD Type in your Project
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How one source columns or rows to be loaded in to two different tables?
What is the use of datastage designer?
Define project in datastage?
client know skid info?
I have a few records just I want to store data in to targets cycling way how?
What are the different plug-ins stages used in your projects?
Give an idea of system variables.
What are the stages in datastage?
how to add a new records into source?
Describe stream connector?
root tree will find which is server job and which is parallel job?
What are the various kinds of containers available in datastage?
What are the steps required to kill the job in Datastage?
