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
- 10569 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
What are datastage sequences?
What is use Array size in datastage
What are some prerequisites for datastage?
What are the difference types of stages?
How do you import and export the datastage jobs?
Define oconv () and iconv () functions in datastage?
How to reverse the string using SQL?
How to find value from a column in a dataset?
Define project in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Does datastage support slowly changing dimensions ?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Differentiate between data file and descriptor file?
What is the difference between passive stage and active stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
