Contents 1 Ab Initio Online Training Concepts 2 TYPES Partition Components 3 Departition Components 4 Multifile System(MFS) USA : +1 940 440 8084, IND : +91 953 383 7156 Email Id : info@maxonlinetraining.com
Contents 5 Transform Components 6 Working with Databases 7 Miscellaneous component 8 Dataset Components USA : +1 940 440 8084, IND : +91 953 383 7156 Email Id : info@maxonlinetraining.com
Contents 9 FTP Components 10 Compress Components 11 Validate Component 12 Translate components USA : +1 940 440 8084, IND : +91 953 383 7156 Email Id : info@maxonlinetraining.com
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@maxonlinetraining.com
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@maxonlinetraining.com
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@maxonlinetraining.com
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@maxonlinetraining.com
Filter by expression
FREE Interactive Live Demo: https://goo.gl/YUzPdw
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@maxonlinetraining.com
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
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@maxonlinetraining.com
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.
Enroll Now : https://goo.gl/KC31Ea
Miscellaneous component • Gather logs • Run program • Redefine format • Trash
FREE Interactive Live Demo: https://goo.gl/YUzPdw
• Replicate USA : +1 940 440 8084, IND : +91 953 383 7156 Email Id : info@maxonlinetraining.com
Dataset Components • Input File • Output File • Lookup File • Intermediate File FREE Interactive Live Demo: https://goo.gl/YUzPdw
Enroll Now : https://goo.gl/KC31Ea
FTP Components • 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@maxonlinetraining.com
Enroll Now : https://goo.gl/KC31Ea
Compress Components • 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@maxonlinetraining.com
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@maxonlinetraining.com
Enroll Now : https://goo.gl/KC31Ea
Translate components • 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@maxonlinetraining.com
Thank You For Free Demo you can call us at USA : +1 9404408084 IND : +91 9533837156