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
10743 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

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

2489

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

1109

How do you import and export data into datastage?

1230

root tree will find which is server job and which is parallel job?

1965

Terminate Activity

1276

Explain the importance of surrogate key in data warehousing?

1187

How to read the length of word in unix?

1377

What are iconv and oconv?

1240

what is repositery?

1841

explain about citrix scheduling tool in datastage

2450

What are the components of ascential data stage?

1185

What are the benefits of datastage?

1236

Difference between data warehousing and olap?

1089

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

1131

What is the difference between datastage and informatica?

1115