Interested to Buy Any Domain ? << Click Here >> for more details...
Source have 1000 records and it can have three nodes ok but
i want how many records are executed on each node?
- 3 Answers
- 10492 Views
- TCS, I also Faced
- E-Mail Answers
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 exact difference between dataset and fileset in datastage?
what is flow of project?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
What are stage variables?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
ename like ibm,tcs,hcl need display those records only how?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
Differentiate between hash file and sequential file?
what is diff b/w datastage 8.1,8.5,8.7?
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
what is the use of DSattchJob?DetachJob? where can we find it?
Teradata 
