One to one training on Datawarehouse and Datastage 8.x (600 USD)
Browse Courses Email to a Friend Course details How online training happens?Steps: Free session -> Make offer or Register -> Mentor accepts and Invoices -> Pay us -> Course begins
Course Info
 |
 Price: 600 USD Get a free session 
Email to a friend |
|
|||
|
|
Feedbacks on online training Post feedback
| No recent feedback |
Questions on online training
| No questions asked yet |
Description of online training
| Brief Description | This is extensive training for 35 hours on Training on DataWarehouse Concept and BM WebSphere DataStage and QualityStage - Version 8.0.1 after which you will be confident about Datawarehousing concept and datastage as an ETL tool.You will be able to ask and assist customer in making there Datawarehouse from scratch |
| Mentor Profile | I am an IT professional having 7 years of experience, which includes 4 years of Training experience. I am an IBM Certified datastage 8.0 consultant & Oracle Certified Companies which have taken my services: • Larsen and toubro • IBM • TCS • Teradata Ltd. Currently, I have taken up the following professional activities: • Training (Corporate and Online) • Content Development (Generating technical questions) • Skills assessment • Conduct technical interviews Expertise: • Datastage 7.5,8.0,8.1 •ï‚ ï€ Teradata 12.0 •ï€ Oracle SQL, PL/SQL,Unix |
| Detail Description | Unit - 1: Data Warehouse Fundamentals An Introduction to Data Warehousing - Purpose of Data warehouse - Data Warehouse Architecture - Operational Data Store - OLTP Vs Warehouse Applications(OLAP) - Data Marts - Data marts Vs Data Warehouses - Data warehouse Life cycle - Metadata management. Unit - 2: Data Modelling Introduction to Data Modelling – Entity Relationship model(E-R model) - Data Modeling for Data Warehouse - Dimensions and fact tables - Star Schema and Snowflake Schemas - Coverage Tables – Different kind of fact tables Unit - 3: ETL Design process Introduction to Extraction, Transformation & Loading - Types of ETL Tools - What to look for in ETL Tools - Key tools in the market - ETL Trends & New Solution Options. Unit - 4: Data stage installation Datastage Installation – Prerequisites to install Datastage – Installation process. Unit - 5: Introduction to Data stage version 8.0.1 Datastage Introduction - IBM Information Server architecture - DataStage within the IBM Information Server architecture - Datastage components - DataStage main functions - Client components. Unit - 6: Datastage Administrator Datastage project Administration - Editing projects and Adding projects - Deleting projects – Global variable setting – Environment management - Runtime Column Propagation(RCP) - Enable Remote Execution of Parallel jobs - Add checkpoints for sequencer - NLS configuration Unit - 7: Datastage Director Introduction to Datastage Director - Validating Datastage Jobs - Executing Datastage jobs – Job execution status - Monitoring a job – Job log view - Job scheduling.- Message Handler Management – Multiple job compile Unit – 8: Datastage Designer Introduction to Datastage Designer – Importance of Parallelism – Pipeline Parallelism – Partition Parallelism – Partitioning and collecting – Symmetric Multi Processing (SMP) – Massively Parallel Processing (MPP) – Partition techniques – Datastage Repository – Palette - Passive and Active stages - Job design overview - Designer work area – Annotations - Creating jobs, deleting jobs - Parameter passing - Compiling jobs – Batch compiling - Validating jobs - Importing flat file definitions - Managing the Metadata environment - Dataset management - Deletion of Dataset – Parameter sets Unit – 9: Working with Server job stages. Database stages Oracle – DB2 – Teradata – ODBC –Universe-Dynamic RDBMS. File stages Sequential file – Folder-Hash file Processing stages Transformer – Aggregator-,Link Collector-Link Partitioner-Merge-Row splitter-Row Merger-Sort Unit – 10: Implementating SCD(Slowly Changing Dimension) in Serevr and parallel job 1)SCD 1.0 2)SCD 2.0 3)SCD 3.0 Unit – 11: Working with Parallel job stages. Database stages Oracle – DB2 – Teradata – ODBC – Sql Server stage. File stages Sequential file – Dataset Processing stages Copy – Filter – Funnel – Sort – Remove duplicate – Aggregator – Modify -- Pivot stage – Lookup – Join – Merge – difference between look up, join and merge - Change capture – Change apply – Surrogate key generator – Transformer. Debug stages Head – Tail – Peek – Column generator – Row generator Restructure stages column export--column import Unit – 12: Advanced stages in Parallel jobs (Version 8.0.1) Range Lookup process – Surrogate key generator stage – Slowly changing dimension stage – Job performance analysis –Slowly Changing Dimensions implementation - Performance tuning. Unit – 13: Job Sequencers Arrange job activities in Sequencer - Triggers in Sequencer – Restability – Recoverability - Notification activity - Terminator activity - Wait for file activity - Execute Command activity - Nested Condition activity - Routine activity - Exception handling activity - User Variable activity - End Loop activity Unit – 14: Migration from one version of Datastage to another version 1)creating folder structure 2)taking backup 3)datastage command Unit – 15: WebSphere Quality Stage About Data Quality - Datastage Quality stages - Investigate stage - Standardize stage -- Unduplicate Match stage Unit – 16: Datastage Interview preparation 1)Question asked on Server job 2)Question asked on parallel 3)Question asked on Datawarehouse 4)Question asked asked on ETL |
How to Join a live session, clas schedule info
You can join for free to check out mentor
How to Join live session
Ask Mentor
How to Join live session
Ask Mentor
Class start, payment details and refund policy
Some courses have minimum learners needed to start.
In case it does not happen class may get delayed or cancelled. Since
we only take money after the class starts, you are not affected.
Payment can be made using paypal or credit card. You need to
have either of this set up in your account. Refund policy is
as described in "Buyers' protection and you get the refund with 2-5
business days.
Buyer Protection
- Step 1: When you pay, you only "authorize" us to pay. The actual money moves from your account after the class starts. If class does not start in the pre-scheduled time, you have an option of withdrawing your authorization.
- Your money is held in a escrow account class gets started. After the course gets over, we check with you if you are satisfied, then only money passed to the mentor. In case you are not, complete or partial refund is given to you after case is handled by our dispute resolution department.
-
Always remember to complete your transactions on LearnersParadise-
it's the safer way to do business.
Is there an offer to pay for the course or get paid directly outside LearnersParadise? If so, please help make the this marketplace safer by reporting it to us. These "outside" transactions may be unsafe and are against our policy.
International Customers
- All our learning/training happens online. So you can join from any part of the world as long as you have broadband internet connection. In fact 25% of our students are from UK, Europe and India. For audio, you can use Skype and for visual you can just use our online meeting tools which works the same way from any location.
-
For payment, we accept all International Visa or Master cards. Since the
course fees are all listed in USD, you still pay in USD. In your credit
card statement, it will show in the currency from your country.
For example: if the course fees is $ 100 and you are from India and exchange rate for that day is = Rs 46.5 You can use your Master/Visa card or paypal to pay 100 in USD just like any studnet from US. your bank statement it will show Rs. 4,650.00 transaction from LearnersParadise.com
Class Start date
Class start date may be unavailable because
- mentor is currently busy with students and has not decide yet on the next class start date or ..
- mentor took a break and have not yet activated the class or fogotten to do so.
- Step 1: Send a quick message to mentor with your interest and see if he/she gets back and activates the listing.
- Note: Mentor may not respond despite your efforts in case he is not available to take the course any more. From our experience in the past most of the mentors respond once they hear from interested people even if their course listing is not showing them active.
