Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Parallel job contains more than 20 stages.
I want to find out which stage is more performance
incentive.

Answer Posted / nish

read the dump score and player timings to find out whioch stages/nodes are taking more CPU time for execution.

consider splitting your job into parts optimally and compare the performance with the original design.

try to reduce number of transformer stages.
Check for unnecessary re-partitioning being introduced.

Hope it helps!

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many Key we can define in remove duplicate stage?

1314


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2167


how to sort two columns in single job in datastage.

2845


How can we improve the performance in datastage?

1059


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

1032


What are the primary usages of datastage tool?

1018


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2928


what is repositery?

1771


Is possible to create skid in dim,fact tables?

2590


What is the importance of the exception activity in datastage?

1018


What are some different alternative commands associated with "dsjob"?

1081


How to implement complex jobs in data stage?

1053


how to write server Routine coding?

2062


What is orabulk stage?

991


What is the differentiate between data file and descriptor file?

1307