Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
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:
Open the Microsoft Excel file.
Highlight the column or group of columns of data to import.
Click Insert > Name > Define.
Enter a name for the selected range and click OK.
If you have multiple sheets, select each sheet and repeat steps 2 to 4 to define ranges for each set of data.