Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 13261 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / kiran
ok well vijay.ur quetion not proper k.
see u can use s_key,column genaretor stage.
and u can define user define query in source level and
populated to target like dbl click on source and set read
method is user deine and write query=select
rownum,ename,sal from emp(s/r table name).k
Thanks&Regards
kiran
9393363309
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the some differences between 7.x and 8.x version of datastage?
How do you generate sequence number in datastage?
What are transforms and what is the differenece between routines and transforms?
what is flow of project?
How do you schedule or monitoring the job?
How to manage date conversion in Datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
To see hidden files in LINIX?
How the ipc stage work?
What is the use of datastage director?
What are data elements?
How many Key we can define in remove duplicate stage?
What are routines in datastage? Enlist various types of routines.
Why do you need stage variables?
