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

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,


Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,


parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  


Why we use surrogate key?

0 Answers  


What is orabulk stage?

0 Answers  


How a routine is called in datastage job?

0 Answers  


how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,


How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,


I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,


Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,


how to delete one row in target dataset

0 Answers   Satyam,


What is difference between join, merge and lookup stage?

0 Answers  


Categories