Here as my knowledge Seq--->Tx---->DS In Tx by using stage varibl

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 / suneelbabu.etl

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

Answer Posted / suneelbabu.etl

Here as my knowledge
Seq--->Tx---->DS

In Tx by using stage varible we can do dis.

Thanks.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are routines in datastage? Enlist various types of routines.

1103

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

How do u convert the columns to rows in datastage?

1195

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167

Differentiate between datastage and datastage tx?

1056

Differentiate between datastage and informatica?

1186

What are the features of datastage flow designer?

1042

How do you remove duplicate values in datastage?

1154

what is the use of materialized view?

1574

What is orabulk stage?

1048

What is the difference between server job and parallel jobs?

1159

What is job control?

1119

What is datastage?

1088

What is the difference between datastage and informatica?

1121

how to abort the job its matain duplicates?

2575