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


Please Help Members By Posting Answers For Below Questions

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2702


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1040


in oracle target stage when we use load option and when we use upsert option?

1748


How to manage date conversion in Datastage?

638


How can we improve the performance in datastage?

647






what is ds administrator used for?

720


What is job control?

622


How do you schedule or monitoring the job?

664


What could be a data source system?

575


What are the processing stages?

640


What is the project in datastage?

665


What are the main differences you have observed between 7.x and 8.x version of datastage?

620


How to reverse the string using SQL?

889


What is ds designer?

651


How do you run datastage job from the command line?

596