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
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 |
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 |
Answer / jay
no. of records processed on each node can be check from director output.
Is This Answer Correct ? | 1 Yes | 0 No |
What is the use of datastage director?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the different type of jobs in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Tell me the syntax of Configuration file?
Name the command line functions to import and export the DS jobs?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
What all the types of jobs you developed?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?