Determine the best value for cschedspins
Determine the best value for cschedspins?
Expert
This is crucial to understand that a cschedspins is a tunable parameter (recommended values being between from 1 to 2000) and the optimum value is fully dependent on the customer's environment. It is used by the scheduler only when this finds that there are no runnable tasks. When there are no runnable tasks then the scheduler has two options:
1. Assume the engine go to sleep (that is done by an OS call) for a given interval or until an event occurs. 2. Go and search for a ready task again.
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
partial specialization and total specialization rules in enhanced erd.......
Describe briefly Aggregate transformation?
Explain the term intelligent binning?
What do you understand by the term denormalization and why would someone consider doing so?
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
Define the explaining plan and how is this used?
Illustrate the difference between the data warehousing and OLAP?
Describe briefly the term data warehouse?
Explain difference types of the stages?
18,76,764
1951045 Asked
3,689
Active Tutors
1422710
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!