first of all question is not clear ok fine if u take source as sequen

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 / ramachandra rao

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

Answer Posted / ramachandra rao

first of all question is not clear

ok fine

if u take source as sequential file there is one option is
there i.e rownumcolumn use this option it will create
sequnce number.

2.use columngenerator also we used

Thanks
chandu-09538627859

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2195

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

1244

Define orabulk and bcp stages?

1112

Explain the importance of surrogate key in data warehousing?

1169

Why we use surrogate key?

1206

What are orabulk and bcp stages?

1105

How a server job can be converted to a parallel job?

1080

how to implement scd2 in datastage 7.5 with lookup stage

5590

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2155

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1726

How do you import and export the datastage jobs?

1141

AGGREGATOR default datatype

1435

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3781

Can you explain link buffering?

1154

Differentiate between Join, Merge and Lookup stage?

1074