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 / 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
What are the features of datastage flow designer?
What all the types of jobs you developed?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is a datastage job?
Where do the datastage jobs get stored?
Define orabulk and bcp stages?
If you want to use a same piece of code in different jobs, how will you achieve this?
how to abort the job its matain duplicates?
How do u convert the columns to rows in datastage?
Difference between in process and inter process?
What is datastage engine?
What are stage variables, derivations and constants?
How rejected rows are managed in datastage?
How can we improve performance of data stage jobs?
Lookup constraints