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.



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

Answer / 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

More Data Stage Interview Questions

What are the different types of lookups in datastage?

0 Answers  


What is Cleanup Resources and when do you use it?

2 Answers  


what is the use of materialized view?

0 Answers   CTS,


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


What is process model?

0 Answers  


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers   IBM,


Define meta stage?

0 Answers  


What are the different kinds of views available in a datastage director?

0 Answers  


which r the connectors used in san?

0 Answers  


How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,


source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,


Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,


Categories