Take source as emp_no,qualification 1,b 2,b 2,c 3,a and reference as date

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.

Question Posted / sriharsha vemuri

4 Answers
10907 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

Please Help Members By Posting Answers For Below Questions

What is aggtorec restructure operator?

1522

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1456

what is 'reconsideration error' and how can i respond to this error and how to debug this

2672

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2412

client know skid info?

2132

How to perform incremental load in datastage?

1260

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

3810

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1554

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2442

Nls stands for what in datastage?

1229

Define repository tables in datastage?

1200

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2323

What are the different type of jobs in datastage?

1082

What is the differentiate between data file and descriptor file?

1410

What is the method of removing duplicates, without the remove duplicate stage?

1075