Ab Initio, Informatica, Datastage training Institute Chennai

Warm Greetings from Greens!

Excellence in Datawarehousing and BI Certification and Real time training
Ab Initio, Informatica, Datastage, MicroStrategy, Cognos, Business Object, OBIEE, ODI and SQL Query Tuning training and certification
We are specialized in providing Ab Initio, Informatica, Datastage, MicroStrategy, Cognos, Business Object, OBIEE, ODI Certification training and Placement

Ab Initio, Informatica, Datastage, MicroStrategy, Cognos, Business Object, OBIEE, ODI and SQL Course duration: Each 40 hrs

Flexible Timings / Weekend classes Available / Fast Track Available on request

Placement assistance will be provided and you will be recommended to IT development firms.

Payment: pay each paper separately after the 2nd day of class or 1st session of class if you satisfy

Please reach out to me for any further clarification. Do pass this info to all your near and dear for utilizing this great opportunity.

Best Regards
Dinesh B.E., MIS (USA)., OCM
91 9840496320 / 044-43511623 / 9940516384
Greens IT Academy
15 first street Padmanabha nagar,
Adyar, Chennai

http://www.youtube.com/watch?v=zFNDxEOfsV0




Ab Initio Training Program

Duration: 80 Hrs

Training Mode: Class Room/On-line

Training Methodology: Real-time Project oriented

Training Features:

1. Trainers from Corporate
2. Unlimited Lab facility
3. Valid Materials (Soft/Hard Copy)
4. Resume Preparation and Mock Interview
5. 100% Placement Assistance



Topics Covered

1. Introduction to Data Warehousing

2. Role of ETL

3. Introduction to Ab Initio

Ab Initio Tool Components (CO>OS, GDE and EME)

Architecture of Ab Initio

Connectivity between GDE and CO>OS

What Ab Initio Programming?

4. Graph Components

Graph Components

DML – Data Manipulation Language

To Prepare the Data (.dat) file

Component Layouts

Graph Development, Execution and debugging

5. Dataset components

Input file

Output file

Lookup file

Intermediate file





Input table
Output table



6. Partition Concepts

Data parallelism

Pipeline parallelism

Component parallelism

7. Partition & De-Partition components

Broadcast

Partition by key

Partition by Expression

Partition by Percentage

Partition by Range

Partition by Round-Robin

Partition with load balancing



De- Partition Components

Concatenate
Gather
Interleave
Merge
8. MFS (Multi-File system)
MFS file system concepts
Difference between serial and MFS file system
9. Introduction to Sub-graphs
Parameters and Input parameters
Variables, Statements and Business Rules
10. Sort components
Sort
Sort within groups
Sample
Find splitter
Partition by key and sort





11. Transform Components

Aggregate

Filter by Expression

Roll-up

Scan

Scan with roll-up

Join

De-dup Sorted

Match- sorted

Reformate

Multi-reformate

Normalize and De-Normalize

12. Database Components

Input table

Output table

Truncate table

Update table

Join with DB

Multi update table

Run SQL

13. Compress Components

Compress

Deflate

Inflate

Uncompress


14. FTP Components

FTP to

FTP from





15. Miscellaneous Components

Gather Logs

Redefine format

Replicate

Run Program

Throttle

Trash

Generate



16. EME (Enterprise Meta> Environment) Tool – Introduction and Overview



Contact Us

Greens IT Academy

11 Padmanabha Nagar, Adyar, Chennai - 600020

Land Mark: Near Adyar Signal

Near Adyar Bus Stop

Phone: 044-43511623

Mobile: +91-9840496320 / 9940516384