When you create a map of a database table or view, the IO Design perspective places the map file in the same folder as the data connection definition (.dcd) file for the database. For example, Figure 2‑26 shows that if you create a map of the table MyTable in the database MyDatabase, the IO Design perspective places the file MyTable.sma in the folder MyDatabase.
Figure 2‑26 Location of a map file for a database table or view
How to create a map of a database table or view
1 In Navigator, select the appropriate project.
2 Choose File➛New➛Map.
3 In New Maps—Data Source:
Select the appropriate data source.
Select Create maps by selecting database tables, as shown in Figure 2‑27.
Figure 2‑27 Creating maps by selecting database tables
Choose Next.
4 In New Maps—Maps:
In Catalog, select the appropriate catalog.
In Filter:
To display tables and views from a particular schema, type the first few characters of the schema name in Schema name prefix, for example, dbo. Do not append an asterisk, for example, dbo*. This filter is case‑sensitive.
To display only tables and views whose names begin with a particular string, type the string in Table/View name prefix, for example, ac. Do not append an asterisk, for example, ac*. This filter is case-sensitive.
Select Show tables only, Show views only, or Show all.
Choose Apply filter.
Move the appropriate tables and views from Available to Selected, as shown in Figure 2‑28.
Figure 2‑28 Selecting tables
Choose Finish.
A reminder appears. Choose OK.
The map file names appear in Navigator. If you created only one map, Output Columns appears.
5 If you created more than one map, double-click the first map file name in Navigator to display Output Columns.
6 In Output Columns, complete the following steps:
Deselect the columns you want to exclude from the map.
To rename a column, type the new name in Name.
Decide on column names before you build an information object from the map. Changing a column name after you build an information object results in a compiler error in the information object.
To create a filter on a column, set the column’s Filter property to Predefined and choose Prompt editor to specify the filter’s prompt properties. Figure 2‑29 shows Output Columns and the location of the Prompt editor button.
To define other column properties, select the column and choose Show map properties.
To modify the default analysis type for a column, choose Default Analytics.
To organize columns in the information object in categories, choose Column Categories.
To change the order of the columns, use up and down arrows.
Select the appropriate data source.
