Muddana, Inc.

Training and Placement : Presently we are offering free training and placement on Teradata technology, which has a good demand in the job market with good salary.

The training program mainly concentrates on Teradata and is designed keeping in view the present technological trends and job demand. We have taken every care so that a trainee gets a job immediately after the successful completion of the training.

We can assure 100% placement if the trainee is with good learning aptitude and commitment. The trainee who undergoes the training with us will be well prepared to handle responsibilities and work with one of the most cutting-edge technologies in the industry. This belief works as a driving force for us to try and ensure that our trainees get a jump start in their career.

We, at Muddana Inc., Training and Placement cell, provide our trainees with the best avenues to utilize their skills by helping them find gainful employment with the best of the industry.

Trainer: A real time hands on experienced professional will provide training with more emphasis on real time environment. Please make a note that this is not a regular classroom-training program.

What we offer: We provide FREE training, computer lab facility, accommodation, H1B sponsorship, resume preparation, interview preparation, and job placement assistance.

Program Contents: The main contents of the training program are:
1. Data warehouse concepts.
2. TeraData: Multi Load, Fast Load, Fast export, Bteq
3. DataStage ETL tool (Extract, Transform, Load)
4. Unix.
5. JCL.
Pre Requisites: Knowledge in SQL,Unix and commitment.

For more details on the training program, please contact Mr. Murali at 727-744-3968. Alternatively you can email murali@muddana.com

Teradata Utilities overview:

BTEQ import

BTEQ export

FastLoad

MultiLoad insert

MultiLoad update

MultiLoad delete

FastExport

Tpump

Module 1 - An Introduction to BTEQ

Logging on to BTEQ

Using BTEQ to submit queries

Interactive Mode and Batch Mode

BTEQ Conditional Logic

Using BTEQ to Export Data

BTEQ EXPORT Example Using Record (DATA) Mode

BTEQ EXPORT Example Using Field (Report) Mode

BTEQ IMPORT

BTEQ Return Codes

BTEQ Commands

Session Control Commands

File Control Commands

Sequence Control Commands

Module 2 - FastLoad

An Introduction to FastLoad

How FastLoad Works

FastLoad Limits

FastLoad Phases – Acquisition and Application

FastLoad Commands

Converting Data Types with FastLoad

FastLoad RESTART

FastLoad CHECKPOINT

Using INMODs with FastLoad

Module 3 - MultiLoad

An Introduction to MultiLoad

Two MultiLoad Modes: IMPORT and DELETE

MultiLoad Limits

Error Tables, Work Tables and Log Tables

Supported Input Formats

Phase 1: Preliminary Phase

Phase 2: DML Transaction Phase

Phase 3: Acquisition Phase

Phase 4: Application Phase

Phase 5: Clean Up Phase

MultiLoad Commands

Parameters for .BEGIN IMPORT MLOAD

Parameters for .BEGIN DELETE MLOAD

Error Treatment Options for the .DML LABEL Command

Redefining the INPUT

What Happens when MultiLoad Finishes

MultiLoad Statistics

Troubleshooting MultiLoad Errors

RESTARTing MultiLoad

RELEASE MLOAD: When Not to Restart MultiLoad

MultiLoad and INMODs

How MultiLoad Compares with FastLoad

Module 4 - TPump

An Introduction to TPump

TPump Abilities and Limits

Supported Input Formats

TPump Commands and Parameters

LOAD Parameters IN COMMON with MultiLoad

.BEGIN LOAD Parameters UNIQUE to TPump

TPump Output Statistics

Monitoring TPump

TPump Error Table

Common Error Codes

RESTARTing TPump

TPump and MultiLoad Comparison

Module 5 – FastExport

An Introduction to FastExport

How FastExport Works

FastExport Fundamentals

FastExport Supported Operating Systems

FastExport Support and Task Commands

FastExport Supported SQL Commands

FastExport Modes and Formats