Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Round Robin for aggregator?is there any benefit
underlying?
- 3 Answers
- 10000 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
Here is the Sample Scenario:
Max sal for each dept
I/P File: Dept
Deptno, Sal
10,21000
10,22000
20,23000
20,12000
30,41000
if you use the Round-robin for 2 node:
SEQ>>AGR>>Tar
no: 10,21000 n1: 10,22000 n2:20,23000
20,12000 30,41000
then the O/P: is all the records from all nodes. because in
no there is no matching deptno.
if you do the hash partition: then
no: 10,21000 n1:20,23000 30,41000
10,22000 20,12000
SO, the O/P: no:10,22000
n1:20,23000
n2:30,41000
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How many types of hash files are there?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the purpose of pivot stage and types of containers in datastage
Where the datastage stored his repository?
What is the importance of the exception activity in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
AGGREGATOR default datatype
What are stage variables?
What all are the different way to run a job?
What are stage variables and constants?
On which Dimension Table you implemented SCD Type in your Project
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
