Source have 1000 records and it can have three nodes ok but
i want how many records are executed on each node?

Answers were Sorted based on User's Feedback



Source have 1000 records and it can have three nodes ok but i want how many records are executed on..

Answer / dilip anand k

Can’t perfectly say how many records are executed on each
node. It all depends on the partitioning method used. If we
use a round robin type the records will be distributed
equally among the nodes. If a Hash method is used where
similar records will be assigned to the same node then it
depends on the data.

Is This Answer Correct ?    16 Yes 2 No

Source have 1000 records and it can have three nodes ok but i want how many records are executed on..

Answer / shilpasagar

The number of records executed on each node depends up on
the partitiong technique used.

But irrespective of partitiong technique there is a way to
get the count of records executed that is through Director

Open Director -> Select the job -> Right click the job and
clic Monitor -> Then select any Stage/Link name and click
Show Instances (If it is already enabled then expand the
stage / link name. Then you can find out the number of
records executed on that particular node.

Is This Answer Correct ?    9 Yes 0 No

Source have 1000 records and it can have three nodes ok but i want how many records are executed on..

Answer / jay

no. of records processed on each node can be check from director output.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  


What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  


what is repositery?

0 Answers   IBM,


What is RCP

5 Answers   CGI, CTS,


What are the steps needed to create a simple basic datastage job?

0 Answers  


what is usage of datastage with materialized views

4 Answers   HP, TCS,


How can we run same job in 1 day 2 times

4 Answers   IBM,


I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  


What are routines in datastage?

0 Answers  


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  


i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,


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

0 Answers  


Categories