By using this site, you agree to our use of cookies. Cookies help us deliver our services. More info

ClassifiedsFree.inComputer ads India
Free computer ads India - search new or used laptops, computers
Home
Menu
Computer ads
Info
About the projectAdvertise successfullyHow to buy or sellContactLinks
RegisterLog in

Professional Training on Datawarehousing - ETL Testing

Duration: 7-8 Weekend Prerequisites Knowledge of Manual Testing Knowledge of DBMS ∕ SQL basics is advantageous. Course Content I. Database ∕ SQL Rdbms Concepts o Data Models o Entity Relationship Model o Normalization o DBMS, Rdbms, Ordbms SQL Overview o Introduction to SQL o Data types o Select Statement o Operators o Pseduo Column SQL Statements o Data Definition Language (DDL) o Data Manipulation Language (DML) o Transaction Control Language (TCL) o Data Control language (DCL) Join o Inner ∕ Equi Join o Non-Equi ∕ Cross Join o Self Join o Outer Join Constraints o Primary Key Constraint o Foreign Key Constraint o Unique Key Constraint o Not Null Constraint o Check Constraint Set Operator o Union o Union All o Intersection o Minus Sub Query o Sub ∕ Inner Query o Correlated Sub Query Object o Index o Synonym o View Built-in Functions o Aggregate Functions o Character Function o String Functions o Case Manipulation Functions o Date Functions o Analytical Functions II. Datawarehouse ∕ ETL Datawarehouse Fundamental o Datawarehouse Overview o DWH Characteristics o Types of Datawarehouse o Data Mart o Database vs Data Warehouse o Data Mart vs Data Warehouse o Data Warehouse benefits o DWH Architecture Datawarehouse Terminologies o Data Cleansing, Partitioning o Staging area, Metadata o OLTP, OLAP, Rolap, Molap o Surrogate Key o Snapshot, View and Materialized View o Meta Data, Data Mining & Data Cube Dimension Modeling o Facts and Dimensions o Hierarchies and Levels o Measures & DWH Schema o Star, Snow-flake and Galaxy Schema o Additive, Semi Additive, Non Additive Fact ∕ Measure ETL Overview o Process Flow of ETL o Types of Sources and Target o ETL Data Load types o Active vs Passive transformation o Extraction Methods in ETL o Tracing Level o Types of Data used for ETL Process Slowly Changing Dimension o What is Slowly Changing Dimension? o SCD Types: Type-1, Type-2, Type-3 ETL Testing Process o Categories of ETL Testing o Types of ETL Testing o How to create ETL Test Case o ETL Test Scenarios and Test Cases o Types of ETL Bugs ∕ Defects o Responsibly of ETL Tester Obiee ∕ BI Overview o Introduction to Obiee o Business Intelligence Basics o Overview of Reports o Slice and Dice o Roll-up and Drill-down & Pivot III. Informatica Power Center Tool Informatica Tool Overview o Introduction to Informatica o How developers work on Power Center o Different components of Power Center and uses o Tasks performed in different Components o Mapping, Session, Worklet, Workflow, Mapplet o Naming Conventions Designer Component o Working with Sources o Working with Flat Files o Working with Targets o Data Transformation Source and Target o Mapping Parameters and Variables o Uses of Mapping Wizards Workflow Manager Component o Workflow Manager Overview o Workflow Designer o Task Developer o Worklet Designer o Using Workflow Wizard o Creating a Task o Configuring Task o Workflow links o Validating Tasks, Workflows o Scheduling and Running Workflows Workflow Monitor Component o Workflow Monitor Overview o Using Workflow Monitor o Working with Tasks and Workflows o Workflow and Task Status o Using Gantt Chart and Task Views o Session and Workflow Logs Transformation o How to use Transformations o Aggregator Transformation o Expression Transformation o Filter Transformation o Router Transformation o Union Transformation o Rank Transformation o Sorter Transformation o Joiner Transformation IV. UNIX ∕ Linux Basics of Unix ∕ Linux o Overview of UNIX Operating System o Useful Commands o Command Manuals o Regular Expressions o Filter o File Attributes o Job Scheduling o Archive ∕ Compress File o Editor: vi, sed o Processes o File copy ∕ transfer in UNIX

Condition: New

Price: ₹ 12000

Date posted:24-08-2018 08:40:21

Ending date (ad expires):24-08-2019(Days remaining: 37)

Region:MaharashtraDistrict:Pune

Phone / mobile:+918...?

Email:? @gmail.com

Web (URL address):http:// ?

Contact person / company:3RI Technologies Pvt Ltd

User - registered since:Advertiser without registration
All / Next classifieds (from this email address)

Posted in category:
Computers, infor. technologyNew Software, applications Offering

Statistics:1294 impressions / 122 visits

Ad owner rating
Rating from portal
100.00 %
  • Number of added data: 3
    • Number of accepted data: 3
    • Number of rejected data: 0
  • Total score from portal: 3

(Data = Classifieds, Companies, Online shops...)
100.00 %
Rating from visitors
0.00 %
  • Number of ratings: 0
    • Number of positive ratings: 0
    • Number of negative ratings: 0
  • Total score from visitors: 0
0.00 %
100
Rate ad owner
bad
good
Classified ad code (ID):
cls-ind-472786

Add to favorites


Professional Training on Datawarehousing - ETL Testing - Similar classifieds


Our professional testing teams skillfully tune the data stores underlying applications i. e. databases, LDAP servers and web servers. We provide cutting-edge testing services for applications that...


Duration: 35-40 Hours Prerequisites Knowledge of Basic Software Testing. Knowledge Of Java Topics 1. Introduction What is Performance Testing? Need of Performance Testing? Methodology used in...


Our professional testing teams skillfully tune the data stores underlying applications i. e. databases, LDAP servers and web servers. We provide cutting-edge testing services for applications that...

Software, applications - District: Pune - Similar classifieds

Professional Training on Agile Performance Testing LoadRunne
Duration: 35-40 Hours Prerequisites Knowledge of Basic Software Testing. Knowledge Of Java Topics 1. Introduction What is Performance Testing? Need of Performance Testing? Methodology used in...

Professional Training on AWS - Amazon Web Services - Archite
Duration: 5-6 Weeks Prerequisites Basic Knowledge of Operation & Infrastructure Basics for AWS 1. Linux Basics Intro to Linux Basic Commands Network Configuration Software Management User and...

Computer ads