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
- 13772 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
Differentiate between Join, Merge and Lookup stage?
Why do you need stage variables?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is difference between symmetric multiprocessing and massive parallel processing?
what are the errors,warnings in datastage
Can you explain link buffering?
Define Data Stage?
Have you used Unstructured data?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is difference between server jobs & parallel jobs?
What is the difference between datastage and informatica?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the partitioning techniques available in link partitioner?
What is the difference between validated and compiled in the datastage?
