Source Execution Group(s) FAQS

1. What is a Source Execution Group?

• A Source Execution Group is a collection of Source Datastores that are grouped together because they either belong to the same dataset or are located on the same physical data server. These datastores can be extracted simultaneously, improving data processing efficiency.

2. How are Source Execution Groups formed?

• Source execution groups are automatically created based on two factors:
• Same Dataset: Source datastores within the same dataset are grouped together.
• Same Physical Server: Source datastores located on the same physical data server are grouped together.

3. What is the benefit of grouping Source Datastores in a Source Execution Group?

• The main benefit is parallel extraction. Datastores within the same execution group can be extracted at the same time, leading to faster data processing and better resource utilization.

4. How are Source Execution Groups displayed in the physical diagram?

• In the physical diagram, source execution groups are visually represented as collections of source datastores that are grouped together. The diagram shows these datastores within the same yellow box to indicate they will be processed in parallel.

5. Can I modify the Source Execution Groups?

• While source execution groups are typically created automatically, depending on the system, you may be able to modify or reconfigure the groups based on your needs to optimize data extraction.

6. Why are Source Execution Groups important for performance?

• They help to optimize performance by allowing the extraction of multiple source datastores simultaneously. This reduces the time needed for data extraction and ensures efficient use of system resources.

7. Do Source Execution Groups always execute in parallel?

• Yes, datastores within a source execution group are extracted in parallel, as long as they belong to the same dataset or physical server. This parallelism speeds up the extraction process.

8. Can Source Execution Groups be manually created?

• Source execution groups are generally created automatically based on the location of the source datastores. However, in some cases, manual adjustments or configurations may be possible, depending on the system settings.

9. What happens if Source Datastores are not grouped in the same Source Execution Group?

• If source datastores are not grouped together, they may not be processed in parallel, which could lead to slower extraction times and less efficient resource usage.

10. Can I have multiple Source Execution Groups?

• Yes, you can have multiple source execution groups within your system. Each group will consist of source datastores that are either from the same dataset or located on the same physical server, allowing multiple sets of tasks to run concurrently.