Wednesday, December 29, 2010

How to Import a Folder in Informaica

This Page shows how to Import a folder(including Source Definitions, Target Definitions, Mappings) into a repository.

Export the folder which you want to import in a different Repository. For more information See this Page.

Open the Informatica Repository Manager and Create a new folder.
Next, open Informatica Designer and double-click the new folder which we created.
Next Click the Repository Menu and Import Objects Menu

you will see the Export Wizard Window, select the xml file which you have exported the folder.
Next, you will see this window

and don't forget to save the Repository.

Then you are done.

Importing XML Source Definition

Open the Designer and click the --> Source Menu --> Import XML Definition
Select the XML file you want to import and then click open


Specify the Naming options for the XML

Next, the window looks like this, click next

After the XML file is imported this how it looks in Source Analyzer.

Create a Target Definition for the output, here in this example I have created a flat file which looks like this.

Drag the source and Target Definitions into the Mapping Designer workspace and link the ports

Create a session and assign it with the mapping above created

Create a workflow and drag the session into the workspace and link together

In the session Mapping Properties make sure the source file name and the path.

Save the repository and run the task.

Import & Create Microsoft Excel Source Definition

Importing a Microsoft Excel Source Definition

PowerCenter treats a Microsoft Excel source as a relational database, not a flat file. Like relational sources, the Designer uses ODBC to import a Microsoft Excel source. You do not need database permissions to import Microsoft Excel sources.
Complete the following tasks before you import an Excel source definition:
  1. Install the Microsoft Excel ODBC driver on the system.
  2. Create a Microsoft Excel ODBC data source for each source file in  the ODBC Data Source Administrator. For more information, see "Connecting to Databases from Windows" in the Installation and Configuration Guide.
  3. Prepare Microsoft Excel spreadsheets by defining ranges and formatting columns of numeric data.

Defining Ranges

The Designer creates source definitions based on ranges you define in Microsoft Excel. You can define one or more ranges in a Microsoft Excel sheet. If you have multiple sheets, define at least one range for each sheet. When you import sources in the Designer, each range displays as a relational source.
You must define a range in the Designer to import the Excel source.
To define a range:
  1. Open the Microsoft Excel file.
  2. Highlight the column or group of columns of data to import.
  3. Click Insert > Name > Define.            
  4. Enter a name for the selected range and click OK.
  5. If you have multiple sheets, select each sheet and repeat steps 1 to 4 to define ranges for each set of data.
  6. Click File > Save.

Formatting Columns of Numeric Data

In Microsoft Excel, you can assign datatypes to columns of data. The Microsoft Excel datatypes are ODBC datatypes. PowerCenter supports  ODBC datatypes and converts them to transformation datatypes as described in Oracle and Transformation Datatypes. If you do not assign datatypes in Microsoft Excel, the Designer imports each column as VARCHAR. If you want to perform numeric or aggregate calculations in a mapping, be sure to assign numeric datatypes in Microsoft Excel before importing the spreadsheet.
To format columns in Microsoft Excel:
  1. Open the Microsoft Excel file.
  2. Select the columns of data that consist of numeric data.
  3. Click Format > Cells.
  4. In the Number tab, select Number.
  5. Specify the number of decimal places, if necessary.
    6. Click OK.
    7. Click File > Save.

Steps to Import a Microsoft Excel Source Definition

After you define ranges and format cells, you can import the ranges in the Designer. Ranges display as source definitions when you import the source.
To import a Microsoft Excel source definition:
  • In the Designer, connect to the repository and open the folder for the source definition.
  • Open the Source Analyzer and click Sources > Import from Database.

  • Select Excel Files (Microsoft Excel Driver (*.xls)) for the data source.
  • Click the Browse button to open the ODBC Administrator.
  • In the User or System DSN tabs, depending on where you created the data source, double-click the Microsoft Excel driver.
  • Click Select Workbook and browse for the Microsoft Excel file, which is considered a relational database.
  • Click OK three times to return to the Import Tables dialog box.
  • Click Connect in the Import Tables dialog box.
    You do not need to enter a database user name and password. The ranges you defined in the Microsoft Excel file appear as table  names. The database owner is No Owner because you are not required to enter a database user name.
  • Select the table you want to import. To select more than one table, hold down the Ctrl or Shift keys to highlight multiple tables.
  • Click OK.
    The newly created source definition appears in the Source Analyzer.
    In the Navigator, the source definition appears in the Sources node, under the database name.
  • Click Repository > Save.

Manually Creating a Source Definition

You can manually create a new source definition.
To create a source definition:
  1. In the Source Analyzer, click Sources > Create.
  2. Enter the name for the source, the database name, and database type.
  3. Click Create.
  4. An empty table structure appears in the workspace. (It  may be covered by the dialog box.) The new source table also appears within the Navigator window.
  5. Click Done when you are finished creating source definitions.
  6. Configure the source definition.
  7. Click Repository > Save.
The new source definition is saved to the repository. You can now use the source definition in a mapping. You can also create a source table based on this definition in the source database.

Import Relational Source & Target Definitions

To import a relational source definition:
  1. In the Source Analyzer, click Sources > Import from Database.
  1. Select the ODBC data source used to connect to the source database.
  2. If you need to create or modify an ODBC data source, click the Browse button to open the ODBC Administrator. Create the data source, and click OK. Select the new ODBC data source.
  3. Enter a database user name and password to connect to the database.
  4. Note: The user name must have the appropriate database permissions to view the object.
    You may need to specify the owner name for database objects you want to use as sources.
  5. Click Connect.
  6. If no table names appear or if the table you want to import does not appear, click All.
  7. Scroll down through the list of sources to find the source you want to import. Select the relational object or objects you want to import.
  8. You can hold down the Shift key to select a block of sources within one folder, or hold down the Ctrl key to make non-consecutive selections within a folder. You can also select all tables within a folder by selecting the folder and clicking Select All. Use the Select None button to clear all highlighted selections.
  9. Click OK.
  10. The source definition appears in the Source Analyzer. In the Navigator, the new source definition appears in the Sources node of the active repository folder, under the source database name.
  11. Click Repository > Save.

Informatica 8.1 step by step Client Installation

This page show how to install and configure the client.

Informatica 8.1 step by step Server Installation

This page show how to install and configure the Informatica server.