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:
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 definition.
To define a range:
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.
To format columns in Microsoft Excel:
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:
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.
To select more than one table, hold down the Ctrl or Shift keys to highlight multiple tables.
In the Navigator, the source definition appears in the Sources node, under the database name.
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.