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
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
If you want to use a same piece of code in different jobs, how will you achieve this?
Can we use target hash file as a lookup ?
What are the areas of application?
What is active and passive stage?
What are the differences between datastage and informatica?
Is it possible to query a hash file?
What are sequencers?
what is 'reconsideration error' and how can i respond to this error and how to debug this
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Why do we use link partitioner and link collector in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is a quality stage in datastage tool?
How to convert RGB Value to Hexadecimal values in datastage?
options available in sequence job to run,validate?