How many partitions does a node can have?
Some body explain me clearly about the partitions and the nodes?
Answers were Sorted based on User's Feedback
Answer / kalyan
Node itself it working as a partition, That means you node
config file is giving the degree of parallelisum, means if
you are using 4 node config file, that job will working on
4 partitions.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / abc
It is the number of nodes in the parallel configuration
file which decides the number of partitions the data will
be split into. Each node acts on one partition.
| Is This Answer Correct ? | 3 Yes | 0 No |
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
What is a ds designer?
What could be a data source system?
What is exact difference between Parallel Jobs and server Jobs..
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
What are stage variables and constants?
What is the difference between datastage and datastage tx?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how many stages are there in Datastage... Please clarify mee??
when u face critical situation in ur project, how to solve them?