A) Read distinct emp_no we get 1,2,3 add a new column and populate as 1 B)

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 / sher

4 Answers
10767 Views
UHG, I also Faced
E-Mail Answers

Answer Posted / sher

A) Read distinct emp_no we get 1,2,3 add a new column and populate as 1
B) read qualification, we get a,b,c add add a new column and populate as 1
Inner join A and B on new columnâ€¦
we get 1-A,1-B,1-C 2-A,2-B,2-C and 3-A,3-B,3-C
Change capture with input file and drop all records with no change.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between datastage and datastage tx?

1059

Difference between sequential file and data set?

1209

Define Merge?

1324

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1288

Whats difference betweeen operational data stage (ods) and data warehouse?

1119

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2498

What are the components of datastage?

1124

Describe link sort?

1018

How do you register plug-ins?

969

How to RD using transformer?

1431

What are datastage sequences?

1126

Name the command line functions to import and export the DS jobs?

1159

What is a folder? Difference types of stages?

1179

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

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

2453