Hi This is pavan u use surrogate key generator.

Hi I have scenario like this

s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000

How can i get target table like that without using
Transformer stage?

Question Posted / pavan

8 Answers
13533 Views
Semantic Space, I also Faced
E-Mail Answers

Answer Posted / pavan

Hi This is pavan u use surrogate key generator.

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differentiate between operational datastage (ods) and data warehouse?

1180

What are the areas of application?

1152

What are the functionalities of link collector?

1085

What are the primary usages of datastage tool?

1075

Could anyone give brief explanation bout datastage admin

2355

what is the use of skid in reporting?

2381

What is the difference between in process and inter process?

1153

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

Differentiate between datastage and informatica?

1186

how to abort the job its matain duplicates?

2574

What are the steps required to kill the job in Datastage?

1218

How to Remove Duplicate using SQL?

1373

How to implement complex jobs in data stage?

1113

Describe link sort?

1018

What are the types of containers in datastage?

1193