[go: up one dir, main page]
Scribd
Upload
22 views3 pages

Ab Initio Course Details

Uploaded by

Arnab Dey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views3 pages

Ab Initio Course Details

Uploaded by

Arnab Dey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

AB INITIO CURRICULUM

1. Introduction to Ab Initio
i. Ab Initio Architecture
ii. Co Operating Systems
iii. GDE
iv. EME

2. Building Simple Ab Initio Graphs


i. GDE – Graph Model
ii. Data Sets
iii. Record formats
iv. DML

3. Ab Initio Components
i. Filter By Expression
ii. Sort
iii. Dedup sort
iv. Reformat

4. Join Component
i. Basic Join
ii. Join types(Inner/Letf/Right/Full)

5. Rollup and Scan Components


i. Roll up
ii. Parameters for roll up
iii. In –memory
iv. Built in functions for Roll up
v. Modes of Roll up
vi. Runtime behavior of roll up
vii. Scan
viii. Parameters for scan
ix. Runtime behavior of scan

6. Dataset components
i. Input file
ii. Intermediate file
iii. Look up file
iv. Converting output file to look up file
v. Output file
vi. Read multiple files
vii. Write multiple files
7. Database components
i. Input Table
ii. Output Table
iii. Update Table
iv. Run SQL

8. Normalize Component
i. Parameters for Normalize
ii. Runtime behavior

9. Ab Initio Multifile System


i. Multifile System Concepts
ii. Creation of MFS and Multidirectory
iii. Performance upgrade due to MFS

10. Partitioning Components


i. Partition by Key
ii. Partition by Round-robin
iii. Partition by Expression
iv. Partition by Percentage
v. Partition by Range

11. De- partitioning Components


i. Gather
ii. Merge
iii. Concatenate
iv. Interleave

12. Miscellaneous Components


i.Redefine format
ii.Generate Records
iii.Trash
iv. Run Program
v. Replicate
vi. Broadcast

13. Sandbox EME and Project Concepts


i. Sandboxes
ii. Concepts of Projects
iii. EME (Covering Check in and check out procedures)

14. Phases and Checkpointing


i. What is a Phase?
ii. What is a Checkpoint?
15. Parallelism and Data Partitioning and Repartitioning Explanation
i. Concepts of Parallelism
ii. Explanation of Data partitioning
iii. Three type of Parallelism

16. Framework & Parameter set overview


i. Generic framework creation
ii. PDL concepts
iii. Parameter set (Pset) usage and creation

17. SUBGRAPH (Collection of different component in one subgraph)

18. PDL(Dynamic XFR/DML generation)

19. CONDUCT-IT(PLAN/SUBPLAN LOOP/RESOURCE POOLING)

20. Interview Preparation along with each class

You might also like