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

What is quality stage?

937

What are data elements?

1106

What are the differences between datastage and informatica?

1112

How many Key we can define in remove duplicate stage?

1315

How many types of stage?

1131

what is ds administrator used for?

1113

How to reverse the string using SQL?

1427

How do you remove duplicate values in datastage?

1097

Differentiate between datastage and datastage tx?

1004

What are transforms and what is the differenece between routines and transforms?

1003

How to perform incremental load in datastage?

1128

Differentiate between data file and descriptor file?

989

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2822

What are the different kinds of views available in a datastage director?

973

Which commands are used to import and export the datastage jobs?

1362