|
Provided by: L'Obel IT-Palaestra ZITT ET Certified Data Warehousing Training CoursesIT Certification Prep |
![]() |
ZITT ET Certified DataWarehousing Training
ZITT ETa ™s DataWarehousing Training course will help you acquire advanced skills for becoming a skilled DataWarehousing Specialist.
Internship Options
ZITT ET is unique in its Datawarehousing Training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its SOFTWARE DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/ her a complete Software Professional.
DATAWAREHOUSING@ZITT ET is designed to make the participant the most sought after Datawarehousing Expert. This makes the participant familiar with the most popular tools and technologies in Datawarehousing. On completion of this course the participant can join the industry as a Datawarehousing Consultant/ Specialist.
Course Syllabus
DATAWAREHOUSING CONTENTS
* What is Data warehouse?
* Characteristics of Data warehouse.
* What is Datawarehousing?
* Principles of Data warehouse.
* Benefits of DWH.
* What is Online transactional systems (OLTP)?
* Difference between OLTP and DWH.
* Architecture of DWH.
* HPQS.
* Approaches of Data warehousing.
* Normalization and Denormalization.
* DWH Lifecycle:
* Data Modeling
* Dimension table
* Fact Table
* Aggregate table
* Schemas
* Star schema
* Snowflake schema
* Types Of Fact Tables:
* Cumulative
* Snapshot
* Fact less Fact
* Types Of Facts:
* Additive
* Semi Additive
* Non Additive
* Confirmed Dimension
* Confirmed Fact
* Degenerated Dimension
* Casual Dimension
* ODS
* Cube
* Hierarchies
* Slowly changing Dimension Concepts
* OLAPa ™s
Erwin
* Getting Started
* Erwin Workplace
* Model Explorer
* Dockable Toolbars
* Stored Display Tabs
* Basic Data Model Objects
* Identifying
* Non-identifying
* Display Levels
* Subject Area
* Indexes
INFORMATICA
* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica Server
* Configuration Temp Server(Workflow Manager)
* Informatica Architecture
* Informatica Client Tools
* Designer (Components)
* Source Analyzer
* Workflow Manager (Components)
* Workflow Monitor
* Repository Manager
* Repository Server Admin Console
* Informatica Server Tools
* Repository Server
* Server
* Transformations
* Source Qualifier
* Filter
* Expression
* Aggregator
* Joiner
* Router
* Rank
* Sorter
* Sequence Generator
* Union
* Xml Source Qualifier
* Lookup (Connected/ Unconnected)
* Stored Procedure (Connected/ Unconnected)
* Update Strategy
* Transaction Control
* Normalizer
* Application Source Qualifier
* Application multi-group Source Qualifier
* Custom
* Mapplet Input
* Mapplet Output
* Midstream XML Generator
* Midstream XML Parser
* Concepts
* SQL Override
* Working with files (Sources, Target)
* File Repository Concept
* Constrained Based Loading
* Parameters
* Mapping Parameters
* Mapping Variables
* Session Parameters
* Incremental Aggregator
* Application Source Qualifier
* Debugging
* Slowly Changing Dimension
BUSINESS OBJECTS
* BO Reporting Tool
* The Query Panel
* Turning Tables to chart
* Formatting Cells/ Tables
* The Structure View
* Insertion of Rows or Columns
* Breaks
* Sections
* Ranking
* Filter
* Alerters
* Crosstabs
* Grouping
* Slice ? and - Dice
* Drill
* Exporting Data
* Data Providers
* Master/ Detail Reports
* Introduction to BO Designer
* Simple Universe and Object Creation
* Creating Hierarchy
* Resolving Loops and SQL Problems
* Supervisor
BUSINESS OBJECTS
* Introduction to Webintelligence
* Getting started with Infoview
* Viewing Documents in Infoview
* Creating New Documents with queries
* Restricting Data returned by a Query
* Displaying information in different ways
* Enhancing report presentation
* Formatting reports
* Creating Formulae and Variables
COGNOS
* Cognos Impromptu
* Power play Window
* Transformer
Cognos Reportnet
* Cognos Reportnet an Architecture
* Cognos connection
* Report studio
* Query studio
* Frame work manager
Course Duration
The duration of the Data Warehousing course is 140 Hours.
Contact us
For more information about this course write to info@lobel. com or walk into our IT Training centers located in Bangalore.
ZITT ETa ™s DataWarehousing Training course will help you acquire advanced skills for becoming a skilled DataWarehousing Specialist.
Internship Options
ZITT ET is unique in its Datawarehousing Training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its SOFTWARE DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/ her a complete Software Professional.
DATAWAREHOUSING@ZITT ET is designed to make the participant the most sought after Datawarehousing Expert. This makes the participant familiar with the most popular tools and technologies in Datawarehousing. On completion of this course the participant can join the industry as a Datawarehousing Consultant/ Specialist.
Course Syllabus
DATAWAREHOUSING CONTENTS
* What is Data warehouse?
* Characteristics of Data warehouse.
* What is Datawarehousing?
* Principles of Data warehouse.
* Benefits of DWH.
* What is Online transactional systems (OLTP)?
* Difference between OLTP and DWH.
* Architecture of DWH.
* HPQS.
* Approaches of Data warehousing.
* Normalization and Denormalization.
* DWH Lifecycle:
* Data Modeling
* Dimension table
* Fact Table
* Aggregate table
* Schemas
* Star schema
* Snowflake schema
* Types Of Fact Tables:
* Cumulative
* Snapshot
* Fact less Fact
* Types Of Facts:
* Additive
* Semi Additive
* Non Additive
* Confirmed Dimension
* Confirmed Fact
* Degenerated Dimension
* Casual Dimension
* ODS
* Cube
* Hierarchies
* Slowly changing Dimension Concepts
* OLAPa ™s
Erwin
* Getting Started
* Erwin Workplace
* Model Explorer
* Dockable Toolbars
* Stored Display Tabs
* Basic Data Model Objects
* Identifying
* Non-identifying
* Display Levels
* Subject Area
* Indexes
INFORMATICA
* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica Server
* Configuration Temp Server(Workflow Manager)
* Informatica Architecture
* Informatica Client Tools
* Designer (Components)
* Source Analyzer
* Workflow Manager (Components)
* Workflow Monitor
* Repository Manager
* Repository Server Admin Console
* Informatica Server Tools
* Repository Server
* Server
* Transformations
* Source Qualifier
* Filter
* Expression
* Aggregator
* Joiner
* Router
* Rank
* Sorter
* Sequence Generator
* Union
* Xml Source Qualifier
* Lookup (Connected/ Unconnected)
* Stored Procedure (Connected/ Unconnected)
* Update Strategy
* Transaction Control
* Normalizer
* Application Source Qualifier
* Application multi-group Source Qualifier
* Custom
* Mapplet Input
* Mapplet Output
* Midstream XML Generator
* Midstream XML Parser
* Concepts
* SQL Override
* Working with files (Sources, Target)
* File Repository Concept
* Constrained Based Loading
* Parameters
* Mapping Parameters
* Mapping Variables
* Session Parameters
* Incremental Aggregator
* Application Source Qualifier
* Debugging
* Slowly Changing Dimension
BUSINESS OBJECTS
* BO Reporting Tool
* The Query Panel
* Turning Tables to chart
* Formatting Cells/ Tables
* The Structure View
* Insertion of Rows or Columns
* Breaks
* Sections
* Ranking
* Filter
* Alerters
* Crosstabs
* Grouping
* Slice ? and - Dice
* Drill
* Exporting Data
* Data Providers
* Master/ Detail Reports
* Introduction to BO Designer
* Simple Universe and Object Creation
* Creating Hierarchy
* Resolving Loops and SQL Problems
* Supervisor
BUSINESS OBJECTS
* Introduction to Webintelligence
* Getting started with Infoview
* Viewing Documents in Infoview
* Creating New Documents with queries
* Restricting Data returned by a Query
* Displaying information in different ways
* Enhancing report presentation
* Formatting reports
* Creating Formulae and Variables
COGNOS
* Cognos Impromptu
* Power play Window
* Transformer
Cognos Reportnet
* Cognos Reportnet an Architecture
* Cognos connection
* Report studio
* Query studio
* Frame work manager
Course Duration
The duration of the Data Warehousing course is 140 Hours.
Contact us
For more information about this course write to info@lobel. com or walk into our IT Training centers located in Bangalore.
Related Software Programs or Products: COgnos,Business Objects,Informatica
Related Awards, Degrees or Certifications: Data Warehousing Certification
Related Jobs or Careers: Data warehousing Professional
|
|
||||||||||||||||||||||||||||
Certificate Program
Provided by L'Obel IT-Palaestra
- M asked: Hi, We would like a team of Dot. Net developers to get trained on COGNOS . from the basics to advanced. Please let us know the following; . Total training hours on COGNOS . Cost of the training per head . Location should be Chennai Thanks Nanda Manager - HR , Block A, th Floor, DLF IT Park, Mount Poonamallee Road, Chennai a INDIA Mobile: +. . Phone: +. . . Fax: +. . . email: com (login required) kutech. com
- M asked: I was willing to inquire about training courses for data warehousing and whether is their any way we can learn it online.
- R asked: where i can get training in bangalore ? please help me
- A asked: looking for data warehousing training. especially datastage and teradata and cognos give all the details thanks in advance
- H asked: Want to know the fee structure, duration and course content for Cognos training?
- V asked: i am venkat from banglore, i want the cognos/ informatica classroom training in banglore, please instruct me.
- A asked: Hi I want a Fast Track Class Room ETL Informatica Traning In Bangalore and starting date should be immediate .. Thanks Abhishek Srivastava + Kormangala, Bangalore
- V asked: Please provide me the contact info for bangalore loacation and the course fee structure Thanks, Vipul
- V asked: Please provide me the contact info for bangalore loacation and the course fee structure Thanks, Vipul
- I asked: Hi, I have around + years experience in mainframe tech. Currenly I am working in project Datawarehouse for past . years. I have fair knowledge in DW concepts..fact & dimensions etc. Now I want to move my career from Mainframes to full time in Datawarehousing..not just technical but a BI resource. Please suggest if it is possible to make this career change and how?. Which courses should I do so that industry accept me in datawarehousing jobs? Please provide some more details about L'Obel DW certifications Thanks, Indra Mobile:
- M asked: Do you offer any classroom course on Ab-Initio or ODI? Please let me know the details.
- A asked: I want to do cognos training in bangalore
- S asked: Interested in taking a datewarehouse and BI certification to become an market research expert similar to BICP (BI cxertified Professional). My cell#
- asked: Whaat is the training cost
- V asked: I want to learn informatica development and administration, can you send me the details of cost, time and the course contents? Thank you,
- O asked: What are the courses available for entry level fresh B. E. graduates who would like to explore career opportunities in data warehousing? Would counselling be provided as to which course to choose?
- M asked: I want to join this course. please provide to me details.
- O asked: I am interested in this course what is the cost implication(amount in us dollar) and duration
- R asked: hello, i am an automotive product designer and wanting to change my career to IT. i am currently interested in data warehousing training and certification. which can get me job as consultant or developer without prior knowledge of IT. please let me know how i should achieve this. rajeev
ZITT ET Certified Data Warehousing Training Courses
DATAWAREHOUSING CONTENTS
* What is Data warehouse?
* Characteristics of Data warehouse.
* What is Datawarehousing?
* Principles of Data warehouse.
* Benefits of DWH.
* What is Online transactional systems (OLTP)?
* Difference between OLTP and DWH.
* Architecture of DWH.
* HPQS.
* Approaches of Data warehousing.
* Normalization and Denormalization.
* DWH Lifecycle:
* Data Modeling
* Dimension table
* Fact Table
* Aggregate table
* Schemas
* Star schema
* Snowflake schema
* Types Of Fact Tables:
* Cumulative
* Snapshot
* Fact less Fact
* Types Of Facts:
* Additive
* Semi Additive
* Non Additive
* Confirmed Dimension
* Confirmed Fact
* Degenerated Dimension
* Casual Dimension
* ODS
* Cube
* Hierarchies
* Slowly changing Dimension Concepts
* OLAP s
Erwin
* Getting Started
* Erwin Workplace
* Model Explorer
* Dockable Toolbars
* Stored Display Tabs
* Basic Data Model Objects
* Identifying
* Non-identifying
* Display Levels
* Subject Area
* Indexes
INFORMATICA
* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica Server
* Configuration Temp Server(Workflow Manager)
* Informatica Architecture
* Informatica Client Tools
* Designer (Components)
* Source Analyzer
* Workflow Manager (Components)
* Workflow Monitor
* Repository Manager
* Repository Server Admin Console
* Informatica Server Tools
* Repository Server
* Server
* Transformations
* Source Qualifier
* Filter
* Expression
* Aggregator
* Joiner
* Router
* Rank
* Sorter
* Sequence Generator
* Union
* Xml Source Qualifier
* Lookup (Connected/ Unconnected)
* Stored Procedure (Connected/ Unconnected)
* Update Strategy
* Transaction Control
* Normalizer
* Application Source Qualifier
* Application multi-group Source Qualifier
* Custom
* Mapplet Input
* Mapplet Output
* Midstream XML Generator
* Midstream XML Parser
* Concepts
* SQL Override
* Working with files (Sources, Target)
* File Repository Concept
* Constrained Based Loading
* Parameters
* Mapping Parameters
* Mapping Variables
* Session Parameters
* Incremental Aggregator
* Application Source Qualifier
* Debugging
* Slowly Changing Dimension
BUSINESS OBJECTS
* BO Reporting Tool
* The Query Panel
* Turning Tables to chart
* Formatting Cells/ Tables
* The Structure View
* Insertion of Rows or Columns
* Breaks
* Sections
* Ranking
* Filter
* Alerters
* Crosstabs
* Grouping
* Slice ? and - Dice
* Drill
* Exporting Data
* Data Providers
* Master/ Detail Reports
* Introduction to BO Designer
* Simple Universe and Object Creation
* Creating Hierarchy
* Resolving Loops and SQL Problems
* Supervisor
BUSINESS OBJECTS
* Introduction to Webintelligence
* Getting started with Infoview
* Viewing Documents in Infoview
* Creating New Documents with queries
* Restricting Data returned by a Query
* Displaying information in different ways
* Enhancing report presentation
* Formatting reports
* Creating Formulae and Variables
COGNOS
* Cognos Impromptu
* Power play Window
* Transformer
Cognos Reportnet
* Cognos Reportnet an Architecture
* Cognos connection
* Report studio
* Query studio
* Frame work manager
* What is Data warehouse?
* Characteristics of Data warehouse.
* What is Datawarehousing?
* Principles of Data warehouse.
* Benefits of DWH.
* What is Online transactional systems (OLTP)?
* Difference between OLTP and DWH.
* Architecture of DWH.
* HPQS.
* Approaches of Data warehousing.
* Normalization and Denormalization.
* DWH Lifecycle:
* Data Modeling
* Dimension table
* Fact Table
* Aggregate table
* Schemas
* Star schema
* Snowflake schema
* Types Of Fact Tables:
* Cumulative
* Snapshot
* Fact less Fact
* Types Of Facts:
* Additive
* Semi Additive
* Non Additive
* Confirmed Dimension
* Confirmed Fact
* Degenerated Dimension
* Casual Dimension
* ODS
* Cube
* Hierarchies
* Slowly changing Dimension Concepts
* OLAP s
Erwin
* Getting Started
* Erwin Workplace
* Model Explorer
* Dockable Toolbars
* Stored Display Tabs
* Basic Data Model Objects
* Identifying
* Non-identifying
* Display Levels
* Subject Area
* Indexes
INFORMATICA
* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica Server
* Configuration Temp Server(Workflow Manager)
* Informatica Architecture
* Informatica Client Tools
* Designer (Components)
* Source Analyzer
* Workflow Manager (Components)
* Workflow Monitor
* Repository Manager
* Repository Server Admin Console
* Informatica Server Tools
* Repository Server
* Server
* Transformations
* Source Qualifier
* Filter
* Expression
* Aggregator
* Joiner
* Router
* Rank
* Sorter
* Sequence Generator
* Union
* Xml Source Qualifier
* Lookup (Connected/ Unconnected)
* Stored Procedure (Connected/ Unconnected)
* Update Strategy
* Transaction Control
* Normalizer
* Application Source Qualifier
* Application multi-group Source Qualifier
* Custom
* Mapplet Input
* Mapplet Output
* Midstream XML Generator
* Midstream XML Parser
* Concepts
* SQL Override
* Working with files (Sources, Target)
* File Repository Concept
* Constrained Based Loading
* Parameters
* Mapping Parameters
* Mapping Variables
* Session Parameters
* Incremental Aggregator
* Application Source Qualifier
* Debugging
* Slowly Changing Dimension
BUSINESS OBJECTS
* BO Reporting Tool
* The Query Panel
* Turning Tables to chart
* Formatting Cells/ Tables
* The Structure View
* Insertion of Rows or Columns
* Breaks
* Sections
* Ranking
* Filter
* Alerters
* Crosstabs
* Grouping
* Slice ? and - Dice
* Drill
* Exporting Data
* Data Providers
* Master/ Detail Reports
* Introduction to BO Designer
* Simple Universe and Object Creation
* Creating Hierarchy
* Resolving Loops and SQL Problems
* Supervisor
BUSINESS OBJECTS
* Introduction to Webintelligence
* Getting started with Infoview
* Viewing Documents in Infoview
* Creating New Documents with queries
* Restricting Data returned by a Query
* Displaying information in different ways
* Enhancing report presentation
* Formatting reports
* Creating Formulae and Variables
COGNOS
* Cognos Impromptu
* Power play Window
* Transformer
Cognos Reportnet
* Cognos Reportnet an Architecture
* Cognos connection
* Report studio
* Query studio
* Frame work manager
About The Training Provider: L'Obel IT-Palaestra
L'Obel IT-Palaestra - ZITT ET is a leading provider of Information technology, Corporate Software Training, Consulting and Business Process Outsourcing services. ZITT ET is Talent Development Corporation, building skilled manpower pool for global industry requirements.
We plays a vital role in providing cost effective Software Training and services to empower clients by deploying business intelligent solutions....

