ab initio online training

June 21, 2018 0 By admin
Spread the love

ab initio online training

Different products of Ab initio
Conduct>IT
Query > IT
Express>IT
BRE
Common Terminology Used in Ab initio
Graph (map)
Subgraph
Plan
DML
xfer
pset
GDE
Sandbox
Checking
Checkout
Lock
GDE Configuration – Host Connection
EME
Introduction
Architecture of EME and Coops
Components
Table
Input Table
Output Table
Update Table
Multi-Update
Truncate Table
File
Input File
Output File
Intermediate File
Lookup File
Read Multiple Files
Write Multiple Files
Compression via Flow – Deflate and Inflate — to compress and decompress the files
Parallelism
Serial and Parallel
Types of Parallelism
Data
Component
Pipeline
Multi-file system creation commands
How to view the multi-file data
How to convert multi-file into Serial File
Partitioning
Partition by Key
Partition by Expression
Partition by Round Robin
Broadcast
Departitioning
Merge
Gather
Concatenate
Interleave
Transform
Reformat
Filter by Expression
Rollup
Scan
Sort
Sort within Group
Dedup Sorted
Normalize
Run Program
Run SQL
Redefine
Trash
Replicate
Leading Record
Replicate
Send Message
Write Excel
Read Excel
Write XML
Read XML
XML Split
Join
Types
Explicit
Inner Join
Full outer Join
CDC – Change Data Capture
Type 1
Type 2
Type 3
Validate
Validate
Generate Records
Parameters
Different Interpretation of Parameters
PDL, $, ${}, Shell
PSET Creation and purpose
Generic Details in GDE
Condition Tab
Phase and Checkpoints
AIR Utility commands
Air
m_db unload
m_dump
Ab Initio Functions
next_in_sequence()
string_upcase()
string_downcase()
string_filter()
string_filter_out()
string_lrtrim()
decimal_strip()
string_substring()

 

 

ab initio online training