Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43895 Views
- MCA, Symphony, TCS, I also Faced
- E-Mail Answers
Answer Posted / raji
1.Avoid using transformer stage for renaming some
columns.Because it will slow down the performance of the
jobs.. Try to use Copy stage for renaming the columns.
2.Take only the required columns during the table level
lookups. Remove all the unnessary columns
3.By using partioning technique. It depends on our
requirement. It will increase the performance as well
| Is This Answer Correct ? | 29 Yes | 4 No |
Post New Answer View All Answers
What is difference between server jobs & parallel jobs?
What is the use of datastage designer?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
CHANGE CAPTURE
what are the errors,warnings in datastage
Describe routines in datastage? Enlist various types of routines.
What are the functionalities of link collector?
How do you generate sequence number in datastage?
Name the command line functions to import and export the DS jobs?
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
how many rows sorted in sort stage by default in server jobs
Name the different types of Lookups in Datastage?
Give an idea of system variables.
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
