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
- 10911 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
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is apt_config in datastage?
what is the use of materialized view?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Give an idea of system variables.
How many types of stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
what is ds administrator used for?
What are the important features of datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the processing stages?
What is meta stage?
How many types of hash files are there?
