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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the repository tables in datastage?
what is ds administrator used for?
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
Can you explain players in datastage?
What is the difference between Datastage 7.5 and 7.0?
What are system variables and sequencers in datastage
What is ds designer?
How to Remove Duplicate using SQL?
What is difference between join, merge and lookup stage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
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
What is the command line function to import and export the ds jobs?
How can one find bugs in job sequence?
Which commands are used to import and export the datastage jobs?