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 |
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
How can you join flat file, oracle as a sources?
How can remove duplicates in a file using UNIX?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
What is the purpose of pivot stage and types of containers in datastage
Pls tell me what is troubleshooting in datastage view?
how can we extract data with out having any common column
how do u reduce warnings
how to sort two columns in single job in datastage.
1)Source file contains one record, I want 100 records in target file.
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
what are .ctl(control files) files ? how the dataset stage have better performance by this files?