Broadcast and replicate does the similar work , what’s the
diff then
Answers were Sorted based on User's Feedback
Answer / chamanvir kaur
Both behave same when input files are serial.
But when its multi file then broadcast do data partitioning
and replicate do component partitioning.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / sreedevi
Broadcast Replicate
1)Broadcast is used for Data parallelism. 1) Replicate mainly used for component parallelism.
2) It can have SFS at in and MFS at out. 2) You cannot have serial layout(SFS) to input and MFS to output.
3) in Broad cast same data is to be dumped to all output flows. 3) In replicate we are not excepting any order of records in the output because it combines the data records arbitarly
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jagdish
Broadcast destributes the records from input based on the block size where as the replicate combines all of the inputs and makes a copy and populates to output.
| Is This Answer Correct ? | 0 Yes | 7 No |
Answer / sainath
Broadcast and replicate both are perform same action ,but main difference is Broadcast is partition component. replicate is not a partition component .
| Is This Answer Correct ? | 0 Yes | 10 No |
Which component breaks the pipe line parallelism in graph?
How can you force the optimizer to use a particular index?
What is the difference between In-Memory Sort and Inputs must be sorted?
What are differences between different versions of co-op?
What is the difference between dml expression and xfr expression?
What is the Reformat Layout?(i/p ->Reformat->o/p)
what is the difference between i)public ii)private iii)common and client projects?
how can you convert 3 way to 7way partitioning in abinitio?
What is rollup component?
explain checkin and checkout?
Broadcast and replicate does the similar work , what’s the diff then
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...