row number column in sequential file

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 / sindhu

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

Answer Posted / sindhu

row number column in sequential file

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is size of a transaction and an array means in a datastage?

1317

What are system variables and sequencers in datastage

1121

What is datastage?

1092

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1041

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

3169

Define data aggregation?

1106

how do u catch bad rows from OCI stage? And what CLI stands for?

2803

EXPLAIN SCD

1414

Can you explain players in datastage?

1207

What are the functionalities of link partitioner?

1025

How to perform incremental load in datastage?

1211

What are the repository tables in datastage?

1311

how to abort the job its matain duplicates?

2576

What is the difference between account and directory options ?

1187

Define Routines and their types?

1194