Informatica Powercenter 9.6 1 Free Download

[Jovanna Ponder]

Ihave a Informatica session which is linked to a wrong mapping.How do i change the mapping from M1 to M2 in the same session S1 and Workflow W1 WITHOUT importing/exporting as XML and making the changes ???

One possible extra option, with disclaimer: If you have access to Informatica's Oracle database (that holds the metadata), you could perhaps make this change directly there. But you would really have to know what you're doing, or else you are likely to mess things up pretty badly. This is certainly not the recommended way of making changes!

The informatica metadata tables confuses you , dont change at that level. All the way is invalidate the mapping by removing port or by syntax errors. Workflw asks you new mapping. This is the best way apart all. Informatica should add new feature to allow us to do this.

XML export is one of the best way.Export the session object and then edit the xml file where you need to change the mapping name. Now when you'd import it, it'll ask for the mapping to associate with.This way you can do it.

What are the various options available for using Excel file as source in Informatica Powercenter 8.6 Please note my informatica server is hosted on Unix Machine. I have 10-12 tabs in excel file, so converting each tab into csv and transfering to unix would be quite tedious. So I want to use Excel file as source.

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.

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.

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. 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, assign numeric datatypes in Microsoft Excel before importing the spreadsheet.

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.

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.

3a8082e126