Hello all Ab Initio developers,

I have recently graduated and I have just joined the Data Warehousing profession, I got some basic training in Ab Intio for few months now and have a few questions, can someone please help me.

1) How does parallelism work in Ab Initio? When and how do you decided when to use the different types of parallelism?
1. Component -- multiple components running on SEPRATE data at the SAME time.
2. Pipe-line -- Multiple components running simultaneously on SAME data at the SAME time.
3. Data -- data divided into sections and operates on all sections simultaneously.

2) How do you select the number of parallelism for Data parallelism? Example: 2-way, 3-way 8-way?


3) What is the number of parallelism Ab Intio can support?

4) When and what is the method used to design Ab Initio graphs?

5) What is a staging area? Is a staging area required in ETL all the time?

6) How does OLAP and ETL work together?

Thanks you all,
April (Anmol)