IBM DB2,Websphere and Datastage training : Chennai

[Guest]

Explore the opportunity in Booming Business Intelligence market

Get trained in hot IBM products ( Only company produces very good job

opportunities )


ObjectArena is a premier IBM DB2,Websphere and Datastage training,

implementation and consulting services company worldwide.
ObjectArena specializes in IBM certifications and offers different

career-oriented courses for IT consultants and Non-IT consultants

worldwide. ObjectArena's training course will provide individuals the

knowledge necessary to work in a real world DB2/Websphere/DataStage

environment.

Our DB2/Websphere/Datastage training programs include live projects and

unlimited lab practice hours. Our courses are designed for specific

industry experience as special classes after the base module.


Join ObjectArena courses based on IBM products which will help you to

explore the booming opportunity in Infrastructure management esp Business

intelligence


Course details

http://objectarena.com/training/DataStage_Chennai.pdf
http://objectarena.com/training/WAS_Chennai.pdf
http://objectarena.com/training/DB2DBA_Chennai.pdf

ObjectArena
Email: hr@objectarena.com
Phone : (91) (44) 42325119 / (91) 9566007935 ( Chennai )
845 790 3446 ( USA )
(65) 64922453( Singapore )

Datastage Course Curriculum



Websphere Datastage Curriculum
Websphere DataStage Module: 01
Introduction
DataStage Architecture.
DataStage Clients
DataStage Designer
DataStage Director
DataStage Administrator
Websphere DataStage Workflow
Websphere DataStage Module: 02
Types of DataStage Job
DataStage Parallel Jobs
Data Stage Server Jobs
Job Sequences
Setting up DataStage Environment
DataStage Administrator Properties
Defining DataStage Environment Variables
Datastage Importing Table Definitions
Datastage Module: 03
Creating Datastage Parallel Jobs
Design a simple Datastage Parallel job in
Datastage Designer
Compile your Datastage job

Run your Datastage job in Director
View the Datastage job log
Datastage Command Line Interface (dsjob)
Datastage Module: 04
Accessing Sequential Data
Datastage Sequential File stage
Data Set stage
Complex Flat File stage
Create Datastage jobs that read from and write
to sequential files
Datastage Reads from multiple files using file
patterns

Use multiple Datastage readers
Null handling in Sequential File
Stage
Datastage Module: 05
Platform Architecture
Describe datastage parallel processing
architecture Describe pipeline &
partition parallelism
List and describe partitioning and
collecting algorithms
Describe configuration files
Explain OSH & Score
Datastage Module: 06
Combining Data
Combine datastage data using the Lookup stage
Combine datastage data using merge stage
Combine datastage data using the Join stage
Combine datastage data using the Funnel stage
Datastage Module: 07
Sorting and Aggregating Data
Sort datastage data using in-stage sorts and
Sort stage

Combine datastage data using Aggregator stage
Remove datstage Duplicates stage
Datastage Module: 08
Transforming Data
Understand ways DataStage allows
you to transform data
using datastage , Create column derivations using userdefined
code and system functions
datastage Filter records based on business
criteria
datastage Control data flow based on data
conditions
Datastage Module: 09
datastage Repository Functions
datastage Performing Simple Find , Advanced
Find and datastage Impact analysis
using datastage ,Compare the differences between two
Table Definitions and Jobs.
Datastage Module: 10
Working with Relational Data using datastage
Import Table Definitions for relational using datastage
tables.
Create Data Connections using datastage
Use datastage Connector stages in a job.
Use datastage SQL Builder to define SQL
Select statements.
Use datastage SQL Builder to define SQL Insert
and Update statements.
Use the DB2 Enterprise stage.
Datastage Module: 11
Metadata in Parallel Framework:
Explain schemas using datastage
Create schemas using datastage, Explain Runtime Column Propagation
(RCP) using datastage
Build a job that reads data from a
sequential file using a schema using datastage
Build a shared container using datastage
Datastage Module: 12
Job Control:
Use the DataStage Job Sequencer to
build a job that controls a sequence of
jobs using datastage
Use Sequencer links and stages to
control the sequence a set of jobs run
in using datastage
Use Sequencer triggers and stages to
control the conditions under which
jobs run using datastage
Pass information in job parameters
from the master controlling job to the
controlled jobs using datastage, Define user variables using datastage
Enable restart using datastage
Handle errors and exceptions using datastage

At the end of the datastage course, Objectarena helps the candidates to

certify in Datastage and shares realtime projects
In today's world, datastage tool is playing important role in Business

intelligence arena.
Objectarena professionals will provide details on solving datastage

issues.

1. General Datastage issues
1.1. What are the ways to execute datastage jobs?
1.2. How to invoke a Datastage shell command?
1.3. How to stop a job when its status is running?
1.4. How to run and schedule a job from command line?
1.5. How to release a lock held by jobs?
1.6. User privileges for the default DataStage roles?
1.7. What is a command to analyze hashed file?
1.8. Is it possible to run two versions of datastage on the same pc?
1.9. How to send notifications from Datastage as a text message (sms) to a

cell phone



2. Datastage development and job design - datastage
2.1. Error in Link collector - Stage does not support in-process active-

to-active inputs or outputs - datastage
2.2. What is the DataStage equivalent to like option in ORACLE - datastage
2.3. what is the difference between logging text and final text message in

terminator stage - datastage
2.4. Error in STPstage - SOURCE Procedures must have an output link -

datastage
2.5. How to invoke an Oracle PLSQL stored procedure from a server job -

datastage
2.6. Is it possible to run a server job in parallel? - datastage
2.7. Error in STPstage - STDPROC property required for stage xxx -

datastage
2.8. Datastage routine to open a text file with error catching -

datastage
2.9. Datastage routine which reads the first line from a text file -

datastage
2.10.How to test a datastage routine or transform? - datastage
2.11.When hashed files should be used? What are the benefits or using

them? -datastage
2.12.How to construct a container and deconstruct it or switch between

local and shared? - datastage
2.13.Corresponding datastage data types to ORACLE types? datastage
2.14.How to adjust commit interval when loading data to the database?

datastage
2.15.What is the use of INROWNUM and OUTROWNUM datastage variables?

datastage
2.16.Datastage trim function cuts out more characters than expected -

datastage
2.17.Database update actions in ORACLE stage - datastage
2.18.Use and examples of ICONV and OCONV functions?
2.19.ERROR 81021 Calling subroutine DSR_RECORD ACTION=2
2.20.How to check Datastage internal error descriptions
2.21.Error timeout waiting for mutex
2.22.ERROR 30107 Subroutine failed to complete successfully
2.23.Datastage Designer hangs when editing job activity properties
2.24.Can Datastage use Excel files as a data input?

ObjectArena Inc
Newyork 12603
Email: hr@objectarena.com
Phone: 845 790 3446
914 204 2581

ObjectArena Inc
103Istfloor,100feetbypassroad
velachery,chennai-600042
near bharat petrol bunk
Email: hr@objectarena.com
phone:91-044-42325119
web:http://www.objectarena.com

ObjectArena Inc
Object Arena Software Solutions Pvt. Ltd.
9/12, Kumaran Colony Main Road
Vadapalani, Chennai - 600 026

Cell: 9566007935

[Guest-IJT]

Name : tejinder kaur
Email : er.tejinder.biotech AT gmail.com
Designation / Skillset : fresher

Resume :

Career Objective :
To secure a challenging position where I can effectively contribute my skills as Biotech Professional, possessing competent Technical Skills.
Educational Qualifications :
Examination
Discipline/
Specialization School/college Board/
University Year of Passing %
B.Tech- M.Tech
(integ.) Biotechnology Engineering LPU, Punjab LPU
2011
73%
+2
Non-medical G.M.S. Sec school, Ldh. P.S.E.B.
2006 70%
10th G.M.S. Sec school P.S.E.B. 2004 86%
Academic Project
Project : Microbial Examination of curd and test presence of bacteriocin
DESCRIPTION
The project work was experimental in nature with an emphasis on microbiological quality of curd and bacteriocin production.
Objectives :
Keeping in mind the significance of strict compliance of quality of curd, and the useful properties bacteriocins exhibit, this study was carried out with the following objectives :
1. To check the microbiological quality of curd.
2. To check production of bacteriocin by lactic acid bacterial isolates.
3. To check the antimicrobial activity of bacteriocin against test pathogenic strains.
I performed experiments like standard plate count, yeast and mould count, enumeration of LAB, some other specific tests related to micro-organisms and bacteriocin. Out of 14 curd samples 2 showed the presence of bacteriocin.
Training : 1 month training from Verka Milk Plant, Ldh.
Computer Skills :
Microsoft office
Languages : C
Personal skills :
Comprehensive problem solving abilities, excellent verbal and written communication skills, ability to deal with people diplomatically, willingness to learn, team facilitator hard worker.

Declaration :
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.
Place : Ludhiana (Tejinder Kaur)
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4343115
Date & Time : 7th Jul 2011 3:25 PM (UTC)
IP Address : 124.253.130.93
Browser Info : Mozilla/5.0 (Windows NT 6.1) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30
Predicted Country []: India