|
- What is Datawarehouse?
- Components of Datawarehouse
- Decision support systems
- OLTP Systems
- OLTP vs DATAWAREHOUSE
- ODS(operational data store)
- Difference between ODS and DATAWAREHOUSE
- Data Mart
- Difference between Datawarehouse and Data Mart
- Difference between Datawarehouse and ODS,OLTP
- Datawarehousing for OLTP systems
- Data cleansing
- Independent Datawarehouse
- Dependent Datawarehouse
- Meta data and Data Mining
- OLAP,ROLAP,MOLA
- ER Model for transactional processing
- Introduction to Data Modeling
- Entities and Attributes
- What is the use of data modeling in Datawarehousing?
- Schema
- Star Schema
- Snowflake Schema
- Snowflake Schema(hybrid schema or galaxy schema)
- Fact table
- Dimension tables
- Multi dimension tables
- Grain warehousing tools consideration
- Granularity for the data warehousing
- Introduction of Informatica power center
- ETL Architecture
- Data source
- Data targets
- Repository
- Meta data
- Server components
- Client components
- SYSTEM REQUIREMENT
- CREATING DOMAIN
- CREATING NODE
- CONFIGURING DOMAIN WITH WEBSERVER
- ASSIGNING INFORMATICA SERVICES WITH ACCOUNT
- Creating Informatica Repository Services
- Creating integrated services
- Creating the workspace(folder)
- Creating the users
- Changing the user passwords
- Creating users groups
- Giving privileges to the users, user groups and folder
- Connecting to the designer
- Components of the designer
- Creating DSN(data source name)
- Source,Database
- Accessing the source,definitions to the designer
- Warehouse Designer
- Creating the target tables using warehouse designer
- Generating target table to database
- Mapping designer
- Mapping between the source and target tables
- Transformations between source and target tables
- Source qualifier
- Aggregator
- Filter
- Expression
- Stored procedure
- Lookup
- Sorter
- Joiner
- Router
- Xml source qualifier
- Update strategy
- Normalizer
- Ranking
- Sequencer generator
- Union
Cubes and dimensions(creating star schema)
Slowly changing dimensions(scd) Mapplets
Reusable transformations Debugger
Working with mapping using debugger
Data Profiling
Variable and Parameters
New features in power centre 7.1
Components of workflow manager
Types of tasks
Creating workflow
Scheduling the workflow
Creating connections
Assigning connection values to the sessions
Assigning server to workflow
Workflow monitor
Session logs
Workflow logs |
