Complete Ab Initio Detailed Training with scenarios

Complete Ab Initio Detailed Training with scenarios

上次更新时间：2021年6月

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

https://www.udemy.com/course/abinitio-detailed-training-with-scenarios/

你将会学到的

Ab Initio GDE with real time scenrios

Ab Initio GDE

要求

Not applicable

No need of any technology knowledge for this course

说明

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



Description of components along with ports.



Simulation with at least one real-time example.



Performance tuning techniques.



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.