Complete Ab Initio Detailed Training with scenarios.

Complete Ab Initio Detailed Training with scenarios.

Hi Folks, in the course we will learn Ab initio very detailed way with real time scenarios, the teached in certain way of every component as below

1. Description of components along with ports.

2. Simulation with at least one real-time example.

3. Performance tuning techniques.

4. Interview questions

By the above things anyone can easily crack the interview and also can perform well in any domain projects!

In the course i have included advanced topics like conduct-it, conversation of stand alone graph to Generic graph, interpretation, scd-2 and cdc structure with logics and all useful commands like General commands , m_commands, air commands,parallelism. Explained one of the project along with creation of tags, what real time challenges will be faced , to whom we need to get in touch.

The explanation is clearly given such a way if new candidate comes to Software industry can easily crack the interview.

Course Content as follows:-

Introduction to Data Warehousing Basis:-

Ab Initio – An Introduction

Ab Initio Products – An Overview

Ab Initio Architecture

Parallelism in Ab Initio

GDE Overview

Data Manipulation Language

Different source system & record format types

------------------------------------------------------------------------------------------------------------------------------------------

Dataset Components – Hands on with the Files/Tables creation required:-

for scenarios

1. Input File

2. Output File

3. Read Multiple files

4. Write Multiple files

5. Lookup File

Database Components:-

1.Input Table

2.output Table

3.Join with DB

4. Truncate Table

5. Update Table

6. Run SQL

------------------------------------------------------------------------------------------------------------------------------------------

Sort Components – Hands on with real time retail warehouse scenario

1. Sort

2. Dedup Sorted

3. Partition By Key & Sort

4. Sort within Group

------------------------------------------------------------------------------------------------------------------------------------------

Transform Components – Hands on with real time retail warehouse:-

1. Reformat

2. Filter By Expression

3. Scan

4. Rollup

5. Join

6. Fuse

7. Normalize

8. Multi Reformat.

9.Scan with Rollup.

------------------------------------------------------------------------------------------------------------------------------------------

Validate Component

1.check order

2.Compare records

3.Compute Checksum

4.Validate record

-----------------------------------------------------------------------------------------------------------------------------------------

Partition Components – Hands on with real time retail warehouse scenario

1. Partition By Key/Key & Sort

2. Partition By Expression

3. Partition By Range, Find Splitters

4. Partition By Round Robbin

DePartiton Components – Hands on with real time retail warehouse

1. Gather

2. Merge

3. Concatenate

4. InterLeave

Phases & Checkpoints

Debugging – Tips & Tricks

------------------------------------------------------------------------------------------------------------------------------------------

Internet Components - Components usage provided in presentation:-

1. FTP/SFTP TO

2. FTP/SFTP FROM

------------------------------------------------------------------------------------------------------------------------------------------

Miscellaneous Components – Hands on with real time retail warehouse

1. Generate Records

2. Replicate

3. Redefine

4. Trash

Parameters – An Introduction, Types, Interpretation

PSET creation & execution

Generic graphs, components

Rollback & Recovery Mechanism

Performance Tuning

Useful Ab Initio commands – m_dump, m_eval, m_wc, m_cp,m_db , etc

Introduction to EME – Code Check In/Check Out, Versioning & Tagging, Save Files.

Working with Vectors

Making and Breaking of vector.

SCD-2 structure

CDC structure

Detailed Material for ever y Component in the Content.

===ALL THE BEST===

GDE explanation and few Advanced Component and Conduct-it and few points on Continuous flows, It will be a worthy buy.

Url: View Details

What you will learn

• Ab Initio GDE with real time scenrios
• Ab Initio GDE

Rating: 3.65

Level: Beginner Level

Duration: 20.5 hours

Instructor: Kumar K