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 / d
d
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of pivot stage?
How to perform incremental load in datastage?
What are some different alternative commands associated with "dsjob"?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is difference between server jobs & parallel jobs?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the important features of datastage?
State the difference between an operational datastage and a data warehouse?
Where do the datastage jobs get stored?
root tree will find which is server job and which is parallel job?
What is the flow of loading data into fact & dimensional tables?
describe the Steps to confiure a Qlogic switch
Give an idea of system variables.
What is usage analysis in datastage?
How and where you used hash file?