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?

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

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2024


What are the repository tables in datastage?

817


what is ds administrator used for?

718


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

534


Can you explain players in datastage?

701






What is the difference between Datastage 7.5 and 7.0?

667


What are system variables and sequencers in datastage

604


What is ds designer?

649


How to Remove Duplicate using SQL?

838


What is difference between join, merge and lookup stage?

634


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2837


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

766


What is the command line function to import and export the ds jobs?

678


How can one find bugs in job sequence?

780


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

978