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
- 11301 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 a datastage macro?
Differentiate between datastage and informatica?
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
Can you filter data in hashed file?
Can you explain players in datastage?
How complex jobs are implemented in datstage to improve performance?
How can we improve the performance in datastage?
what is the use of surogate key in datastage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Explain how a source file is populated?
How to RD using transformer?
What are stage variables and constants?
What is the difference between Datastage 7.5 and 7.0?
root tree will find which is server job and which is parallel job?
Define Routines and their types?
