Datawarehouse Architect

DAC Setup View Tabs   Setup View: In the Setup view, you are able to set DAC system properties, Informatica server connection information and physical data source connection information for all source and target databases. Parent Pane Tab: DAC System Properties – Modify DAC server properties. Child Pane Tabs: Edit – Modifies the property value. Description – Contains an overview of the properties.   Parent Pane Tab: Informatica Servers– Enables the Informatica repository and integration services. Child Pane Tabs: Edit – Contains the name, type, integration server/host, max session, and other various  Informatica component properties. The login user name and password will be used to run the  workflows. Parent Pane Tab: Physical Data Sources – Create, modify and delete physical data source connections. Child Pane Tabs: Edit – Contains the name, connection information, source type, default index location and data  source number Refre...

  Design View Tabs Setup View: In the Setup view, you are able to set DAC system properties, Informatica server connection information and physical data source connection information for all source and target databases. Parent Pane Tab: Subject Areas – The Subject Area Tab is used to create and assemble subject areas.   Child Pane Tabs: Edit – Define or change the name of the subject area. Tables – Add or remove the primary fact tables associated with the subject area. Configuration Tags – Apply a configuration tag to a subject area. Tasks – View, add, remove, or inactivate tasks associated with the subject area.   Parent Pane Tab: Tables – Defines source and target tables and their respective columns.   Child Pane Tabs: Edit – Name the table, identify the type of table, and indicate whether or not the table exists in the warehouse. Related Tables – Associate related tables that will be included in the subject area. Related tables are generally Aggregates of facts. C...