21/06/2012 Computer - Multimedia Classes
Course Content for Inf 8.1, B O XI R2 &Cognos 8
Basic Concept of Datawarehousing
Data modeling Concepts
Physical Data Modeling and Logical Data Modeling
Star Schema and Snow Flake Schema
ETL Process Flow
Reporting Process Flow
Extraction, Transformation and Loading (ETL)
Configuring the Repository Server
Starting the Repository Server
Configuring Informatica Server
Process involved in creating Repository in Administrator Console and starting the repository.
Taking Backup and restoring the repository.
Working with Repository Manager.
Creating folders, users, groups, granting privileges etc.
Working with Designer
Process involved in Extraction transformation and loading of tables.
Importing and Exporting Source and Target Metadata.
Creating Target Tables with constraints
Involved in creating of simple mapping and complex.
Types of Transformation
Source Qualifier Transformation
Update strategy Transformation
XML Source Qualifier Transformation
Transaction control Transformation
Process involved in Extraction of data from Flat file to Database and vice versa.
Process involved in Extraction of data from XML file to Database.
Creating Reusable Transformation in Transformation Developer
Creating Reusable Objects in Mapplets Designer.
Involved in Exporting and Importing Mapping and metadata.
Cube and Dimensions
Involved in Creating Dimension
Involved in Creating Cubes.
Creating complex mapping for Cubes and dimension.
Creating workflow for the cubes and dimension mapping.
Testing the workflow.
Slowly Changing Dimension
Type 1: Involved in the creation of mapping and testing the output
Type 2: Involved in the creation of mapping and testing the output
Type 3: Involved in the creation of mapping and testing the output
Working with Workflow Manager
Involved in creation of Tasks Such as Session, Command and Email.
Working with Task Developer.
Involved in creation of simple and comples workflow.
Involved in creation of Batch Session.
Running the workflow.
Configuring the web brower and Assigning web server.
Involved in creation of scheduler and configuring the scheduler.
Working with Workflow Monitor
Monitoring the session and workflow.
Troubleshooting the errors.
Checking log property.
Checking the output with session log.
Checking the Performance statistics.
No.15 First Street,Padmanabhanagar,
Phone(M): +91 98404 96320
Phone(L): 044 43511623
Best Informatica Training Centre in Chennai / iSkill TechWebsite:http://www.iskilltech.com/ Branch: New # 84 / Old #45-A, Venkatrathnam Nagar, Adyar, ...
Best Informatica Training Institute In Chennai Adyar with 100% placement. No 1. Best Informatica training institute in Chennai adyar.. Course N...
Best informatica training institute in chennai Adyar Guindy saidapet medavakkam SRP ========Friendly Contact==Mr.N.Parthiban===9940516384============...
Greens Technologies Best Informatica training institute in chennai Adyar Rajesh@ 9840496320 / 9940516384 - Greens Technologies Now a days ETL tool pla...