Follow Us on :TwitterDiggFacebookLinkedin

Classified Details :
Duration: 40 Hours Prerequisites Basic knowledge of Software Testing. Course Content 1. Module I (Database/SQL) Database Overview DBMS, RDBMS, ORDBMS Why Database Required SQL Overview DDL, DML, DCL, TCL Data types SELECT Statement Restricting and Sorting Data Aggregating Data using Group Functions Creating and managing Tables Manipulating Data Sub queries Important Functions Joins and different types Views Index Synonym Constraints Set Operator 2. Module II (UNIX/LINUX) Overview of UNIX Operating System Basic commands and concepts Command Manuals Regular Expressions Input/Output Redirection Piping Filter Details explanation of File Attributes Job Scheduling Archive/Compress File Environment variables Basic of Editor : vi, sed Quoting and Escape Mechanism Types of Variables Operator Shell Arithmatic How to to write, execute and debug Shell Script Program 3. Module III (Datawarehousing Concepts) What is Datawarehouse ? Why Datawarehouse require ? DWH Architecture DWH Characteristics Data Mart and types DM vs DWH Common Datawarehouse tasks Data cleansing Partitioning Staging area Metadata OLTP, OLAP, ROLAP, MOLAP Surrogate Key Dimension Modeling Facts and Dimensions DWH Schema designing Advantages of Datawarehouse Star Schema, Snow-flake Schema, Galaxy Schema OBIEE/BI Overview Overview of Reports 4. Module IV (ETL Concepts) Types of Source Files Data Extraction Different types of Transformations Data Loading Slowly Changing Dimension SCD (Type-1, Type-2 and Type-3) Introduction of ETL Tool Overview of ETL Tool Architecture ETL Tool Environment 5. Module V (Informatica Power Center Tool) How developers work on Power Center Different components of Power Center and uses Tasks developed in different components Mapping, Session, Worklet, Workflow, Mapplet
Posted On :
March 03, 2017

City :

Category :

Sub Category :
Professional Courses

Advertiser Details
Company Name :3ritechnologies
Contact Name :ritesh sharma
Location :Pune, India
Mobile / Phone No: 9028250057
Posted Date :March 03, 2017
Website Url
Print this Page

Send Query to Advertiser
Your enquiry message :
Name :
Email :
Phone :
Verify your Request
verification image, type it in the box