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
- 11205 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / pavan
Hi This is pavan u use surrogate key generator.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is the use of datastage director?
What are the features of datastage flow designer?
How to read the length of word in unix?
Have you have ever worked in unix environment and why it is useful in datastage?
How to manage date conversion in Datastage?
What are the components of ascential data stage?
How many areas for files does datastage have?
options available in sequence job to run,validate?
What are the main features of datastage?
What is the process of killing a job in datastage?
Which algorithm you used for your hashfile?
Terminate Activity
What are the different plug-ins stages used in your projects?
What are stage variables, derivations and constants?
State the difference between an operational datastage and a data warehouse?
