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 |
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?
What are the enhancements made in datastage 7.5 compare with 7.0?
what is repositery?
What is RCP
What are the steps needed to create a simple basic datastage job?
what is usage of datastage with materialized views
How can we run same job in 1 day 2 times
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?????
What are routines in datastage?
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
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?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?