ABINITIO Online TRAINING from maxonlinetraining

1
(No Transcript)
2
Contents
1
Ab Initio Online Training Concepts
TYPES Partition Components
2
Departition Components
3
Multifile System(MFS)
4
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
3
Contents
5
Transform Components
6
Working with Databases
Miscellaneous component
7
Dataset Components
8
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
4
Contents
9
FTP Components
10
Compress Components
Validate Component
11
Translate components
12
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
5
Ab Initio Online Training Concepts

• Introduction to Ab initio with excellent
  faculties
• Ab initio detailed architecture
• Features of Ab Initio Graph, Component, Ports,
  DML
• Introduction to .dat and .dml files
• Ports available on overall components

USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
6
Departition Components

• Concatenate
• Gather
• Interleave
• Merge

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
7
Multifile System(MFS)

• Types of parallelism
• Layouts
• Sort Components
• Sort
• Sort with in groups
• Sample
• Partition by key and sort

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
8
Transform Components

• Filter by expression
• Aggregate
• Scan
• Rollup
• Denormalize Sorted
• Normalize
• Reformat
• Match sorted
• Dedup sorted

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
9
FREE Interactive Live Demo https//goo.gl/YUzPdw
Filter by expression
Filter by Expression filters data records
according to a specified DML expression.Basically
it can be compared with the where clause of sql
select statement.Different functions can be used
in the select expression of the filter by
expression component even lookup can also be used.
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
10
(No Transcript)
11
Join
Join reads the records from multiple ports,
operates on the records with matching keys using
a multi input transform function and writes the
result into output ports.
Reformat 
Reformat changes the record format of data
records by dropping fields, or by using DML
expressions to add fields, combine fields, or
transform the data in the records. By default
reformat has got one output port but incrementing
value of count parameter number. But for that two
different transform functions has to be written
for each output port.
FREE Interactive Live Demo https//goo.gl/YUzPdw
12
Working with Databases

• Database components
• Run SQL
• Input Table
• Output Table
• Truncate Table
• Update table

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
13
Database components are generally used to read
from/ write to different databse. The basic
database components are run sql , input
table, output table.
Input Table unloads data records from a database
into an Ab Initio graph, allowing you to specify
as the source either a database table, or an SQL
statement that selects data records from one or
more tables.
Output Table loads data records from a graph into
a database, letting you specify the records'
destination either directly as a single database
table, or through an SQL statement that inserts
data records into one or more tables. 
Run sql is a database component. It executes SQL
statements in an Oracle or SQL Server database.
14
Miscellaneous component
Enroll Now https//goo.gl/KC31Ea

• Gather logs
• Run program
• Redefine format
• Trash
• Replicate

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
15
Dataset Components

• Input File
• Output File
• Lookup File
• Intermediate File

FREE Interactive Live Demo https//goo.gl/YUzPdw
16
FTP Components
Enroll Now https//goo.gl/KC31Ea

• FTP From
• FTP To

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
17
Compress Components
Enroll Now https//goo.gl/KC31Ea

• Compress
• Uncompress
• Gzip
• Gunzip

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
18
Validate Component

• Check Order
• Generate Records
• Generate Random bytes
• Compare Records
• Compute Check Sum
• Compare Check Sum

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
19
Translate components
Enroll Now https//goo.gl/KC31Ea

• Record XML
• Write XML
• Project and Sandbox
• Performance Tuning

FREE Interactive Live Demo https//goo.gl/YUzPdw
USA 1 940 440 8084, IND 91 953 383
7156 Email Id info_at_maxonlinetraining.com
20
Thank You
For Free Demo you can call us at  USA 1
9404408084 IND 91 9533837156