overview -:

The Designer has tools to help you build mappings and mapplets so you can specify how to move and transform data between sources and targets. The Designer helps you create source definitions, target definitions, and transformations to build the mappings.

The Designer includes windows so you can view folders, repository objects, and tasks. You can work in multiple folders and repositories at one time.

You can configure general Designer settings, such as font and background color. You can also configure specific tool settings for each Designer tool.

Designer Tools

The Designer provides the following tools:                          overviewStatus Bar
                                                                                              2.Navigator
                                                                                              3.Output
                                                                                              4.Workspace
                                                                                         
Source Analyzer. Import or create source definitions for flat file, XML, COBOL, Application, and relational sources.
Target Designer. Import or create target definitions.
Transformation Developer. Create reusable transformations.
Mapplet Designer. Create mapplets.
Mapping Designer. Create mappings.
Designer Windows

The Designer consists of the following windows:

Navigator: Connect to multiple repositories and folders. You can also copy and delete objects and create shortcuts using the Navigator.

Workspace: View or edit sources, targets, mapplets, transformations, and mappings. You work with a single tool at a time in the workspace, which has two formats: default and workbook. You can view multiple versions of an object in the workspace.

Status bar:Displays the status of the operation you perform.

Output.:Provides details when you perform certain tasks, such as saving work or validating a mapping. Right click the Output window to access window options, such as printing output text, saving text to file, and changing the font size.

Overview:View workbooks that contain large mappings or a lot of objects. The Overview window outlines the visible area in the workspace and highlights selected objects in color. To open the Overview window, click View > Overview Window.
Instance Data. View transformation data while you run the Debugger to debug a mapping.
Target Data. View target data while you run the Debugger to debug a mapping.
You can view a list of open windows, and you can switch from one window to another in the Designer. To view the list of open windows, click Window > Windows.

The following figure shows the Designer windows:

There are 5 Key areas to understand in Data Warehousing-Informtica

There are 5 Key areas to understand in Data  Warehousing:(To understand this concept,  knowledge on Relational  databases and SQL is necessary)

1.DATABASE
2.ETL [Extraction, Transformation & Loading]
3.OLAP
4.REPORTING
5.METADATA
- - - - - - - - - - - -
1.DATABASE –
To understand the storage of data with RDBMS Process

Popular Relational Databases are:

*ORACLE
* MICROSOFT SQL SERVER
*IBM DB2
*TERADATA
*SYBASE
*MYSQL

2.ETL [Extraction; Transformation & Loading] – To understand cleansing of Data from DB’s.

Popular ETL Tools are:

*INFORMATICA
*DATA INTEGRATION STUDIO [SAS]
*ODI
*SQL Server Integration Services [Microsoft]
*DATA STAGE
*AB INITIO
*TALEND and many more..

3.OLAP : – To understand Slicing & Dicing of the Data.

Popular OLAP Tools are:

*OBIEE [Oracle Business Intelligence]
*BUSINESS OBJECTS [SAP]
*OLAP CUBE STUDIO [SAS]
*COGNOS [IBM]
*SQL Server Analysis Services [Microsoft]
*MICROSTRATEGY
* PALO OLAP SERVER
*HYPERION [Oracle] and many more...

4.REPORTING – To understand the Reporting requirement on Regular Automations & Adhoc’s

Popular Reporting Tools are:

*CRYSTAL REPORTS [SAP]
*MICROSTRATEGY
*OBIEE [Oracle Business Intelligence]
*WEB REPORT STUDIO [SAS]
*COGNOS [IBM]
*SQL Server Reporting Services [Microsoft]
*HYPERION [Oracle]
*Actuate
*Jaspersoft
*Pentaho and many more...

5. METADATA – To build data repositories from the scratch and it is a rare phenomenon

Data warehouses Basis:-

Data warehouses are widely used within the largest and most complex businesses in the world. Use with
in moderately large organizations, even those with more than 1,000 employees remains surprisingly low
at the moment. We are confident that use of this technology will grow dramatically in the next few
years.

In challenging times good decision-making becomes critical. The best decisions are made when all the
relevant data available is taken into consideration. The best possible source for that data is a welldesigned
data warehouse. To make any new decision or to introduce new Plan data warehousing is very
important.

ETL is one of the main processes in data warehousing. ETL means extract transform and Load data into
data warehouse.Informatica is ETL tool. It is very flexible and cheaper as compared to other ETL tool.

Introduction to Informatica :-

Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process.
Now days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic.
 You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings.
Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them.
It can move huge volumes of data in a very effective way, many a times better than even bespoke programs
written for specific data movement only. It can throttle the transactions (do big updates in small chunks
to avoid long locking and filling the transactional log).
It can effectively join data from two distinct data
sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to
effectively integrate heterogeneous data sources & converting raw data into useful information

FAQ-:

Q:COURSE ELIGIBILITY: WHO CAN DO THIS COURSE ..??

ANS:Any Graduate who wish to make his career .

Q:What You People Should Know Before Going this coures ??
Ans: To understand this concept, knowledge on-
Relational databases(RDBMS) and SQL is necessary.

Q.TRAINING PROGRAMS – DURATION & FEE DETAILS
Ans. 2Months(2x6)=12 Hrs per week & Fee =10000/- differ

It guides you in 5 ways thus leading to a 5 P concept of Planning, Practicing, Preparation, Presentation and Personality.

It guides you in 5 ways thus leading to a 5 P concept of Planning, Practicing, Preparation, Presentation and Personality.

Data warehouses Basis:-

Data warehouses Basis:- Data warehouses are widely used within the largest and most complex businesses in the world. Use with in moderately large organizations, even those with more than 1,000 employees remains surprisingly low at the moment. We are confident that use of this technology will grow dramatically in the next few years. In challenging times good decision-making becomes critical. The best decisions are made when all the relevant data available is taken into consideration. The best possible source for that data is a welldesigned data warehouse. To make any new decision or to introduce new Plan data warehousing is very important. ETL is one of the main processes in data warehousing. ETL means extract transform and Load data into data warehouse.Informatica is ETL tool. It is very flexible and cheaper as compared to other ETL tool.

This blogs gives you details of Data Warehousing - Informatica & SQL techniques.