Price: 2.00 ₹

Description

best informatica training centre in Chennai


Data Warehousing


Course Content for Inf 8.1, B O XI R2 & Cognos 8


Introduction:


Basic Concept of Datawarehousing


Datawarehousing Architecture


Data modeling Concepts


Physical Data Modeling and Logical Data Modeling


Star Schema and Snow Flake Schema


ETL Process Flow


Reporting Process Flow


Informatica 8.1


Extraction, Transformation and Loading (ETL)


Administration


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


Expression Transformation


Aggregator Transformation


Filter Transformation


Router Transformation


Joiner Transformation


Source Qualifier Transformation


Lookup Transformation


Update strategy Transformation


XML Source Qualifier Transformation


Sorter Transformation


Ranker Transformation


Custom Transformation


Union 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.


Contact


 


Best Regard’s


Cignas Technologies


Mylapore  Chennai,


Contact :-


N.Parthiban


9791031769


 

More Details

Total Views:5
Reference Id:#123711
Phone Number:919840496320
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com