What is BRODCASTING and REPLICATE?
Submitted by: AdministratorBroadcast - Takes data from multiple inputs, combines it and sends it to all the output ports.
Eg - You have 2 incoming flows (This can be data parallelism or component parallelism) on Broadcast component, one with 10 records & other with 20 records. Then on all the outgoing flows (it can be any number of flows) will have 10 + 20 = 30 records
Replicate - It replicates the data for a particular partition and send it out to multiple out ports of the component, but maintains the partition integrity.
Eg - Your incoming flow to replicate has a data parallelism level of 2. with one partition having 10 recs & other one having 20 recs. Now suppose you have 3 output flos from replicate. Then each flow will have 2 data partitions with 10 & 20 records respectively.
Submitted by: Administrator
Eg - You have 2 incoming flows (This can be data parallelism or component parallelism) on Broadcast component, one with 10 records & other with 20 records. Then on all the outgoing flows (it can be any number of flows) will have 10 + 20 = 30 records
Replicate - It replicates the data for a particular partition and send it out to multiple out ports of the component, but maintains the partition integrity.
Eg - Your incoming flow to replicate has a data parallelism level of 2. with one partition having 10 recs & other one having 20 recs. Now suppose you have 3 output flos from replicate. Then each flow will have 2 data partitions with 10 & 20 records respectively.
Submitted by: Administrator
Broadcast is used to increased the data parallelism by connecting fan-out flow to the output.Replicate is used to increase the component parallelism by connecting multiple straight flow to the output.
Submitted by: Manjunatha
Submitted by: Manjunatha
Read Online Ab Initio Job Interview Questions And Answers
Top Ab Initio Questions
☺ | How do you convert 4-way MFS to 8-way mfs? |
☺ | What is skew and skew measurement? |
☺ | What is local and formal parameter? |
☺ | What is the difference between rollup and scan? |
☺ | What does dependency analysis mean in Ab Initio? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |