Begin introspection by selecting a data source to examine and then choosing a minischema option.
To begin introspection and choose a minischema option:
In the Data Source Navigator, right-click the data source on which you want to perform introspection, and select Introspect.
Create a new schema diagram—If you choose this option, enter a name for the new minischema.
Skip minischema diagram—If you choose this option, you still are guided through the introspection process, but you will not create a minischema diagram.
Note: | If you are accessing a text file data source, you may create a minischema, but it will not contain joins. |
Ensure that Use Introspection to Detect Hierarchies is selected.
Click Next; or, if you chose not create a minischema, click Finish.
Clicking Next takes you to the Select Fact Tables page of the wizard, as described in Populating a Minischema for Relational Sources.