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
- 13769 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 stage variables?
What are the components of datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What could be a data source system?
Define project in datastage?
How do you import and export the datastage jobs?
How to RD using transformer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
what is flow of project?
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
Define Merge?
Differentiate between data file and descriptor file?
What is the different type of jobs in datastage?
What is the importance of the exception activity in datastage?
How and where you used hash file?
