
- Forum
- Databases
- Data Warehousing - If Session takes long time to run, how to improve its speed
-
Junior Member
If Session takes long time to run, how to improve its speed
If Session takes long time to run, how to improve its speed
-
Junior Member
Re: If Session takes long time to run, how to improve its speed
help me with this question!!11
Suppose you have a very long steel bar, with a regular pentagonal cross-section where each side of the pentagon is 2 cm in length. This bar will be suspended vertically over a very deep chasm. At the bottom end of the steel bar, there is a spherical steel weight with a diameter of 50 cm. Going up the bar, at every 3 metre increment, there is a spherical steel weight with a diameter of 30cm.
If the density of the steel is exactly 7.8 g/cm3, the steel can withstand a tensile stress of 400 MPa, and gravity is 9.81m/s2, what is the maximum possible length, in metres, that the bar can extend without breaking? Round down to the nearest metre, submit only a number (with no additional or extraneous information), and disregard any deformation of the bar or any other forces acting on the bar.



-
Junior Member
Re: If Session takes long time to run, how to improve its speed
This is a common question asked in interviews. To increase the session performance there are different options:
1. Pipeline Partioning ( The best solution)
2. Increase size of cache if your session uses Aggregrator, Rank, Lookup and joiner transformations
3. Increase commit intervals.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules