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
- 13443 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / surya
you can generate surrogate key in the transformer itself.
right click on the stage variables. tre you can find surrrogate key.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are datastage sequences?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define APT_CONFIG in Datastage?
Differentiate between Join, Merge and Lookup stage?
What are the functionalities of link partitioner and link collector?
What are system variables and sequencers in datastage
How will you move hashed file from one location to another location?
What are the types of hashed files in data stage
Can you explain players in datastage?
Why fact table is in normal form?
What are the different common services in datastage?
How to Remove Duplicate using SQL?
Describe the architecture of datastage?
