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
10760 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 are the differences between datastage and informatica?

1177

How to reverse the string using SQL?

1526

What is the difference between operational data stage (ods) and data warehouse?

1242

State the difference between an operational datastage and a data warehouse?

1131

How to manage date conversion in Datastage?

1138

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2446

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

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

1026

How do you remove duplicate values in datastage?

1151

Differentiate between Join, Merge and Lookup stage?

1092

How a routine is called in datastage job?

1108

Nls stands for what in datastage?

1190

What are the types of containers?

1237

What is the roundrobin collector?

1099

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089