Getting Started with DAC 11g

After creating login to DAC , the below things have to be configured to start a data  load.

1.Set Environment Variables

PATH, INFA_HOME and INFA_DOMAINS_FILE

2.Create Connection to Informatica Server

In the DAC, navigate to Views>Setup>Informatica Servers

1. Click New,and enter Informatica Repository Service details.


2. 


3. Make sure connection tested successful


4. Click New,  enter Integration Service details


5. 


6. Make sure connection tested successful.

3.Create Physical Data Sources

1. In the DAC, navigate to Views>Setup >Physical Data Sources


2. Click New, enter database connection information


3. 


4. Make sure connection tested successful.


5. Also create Data Source for Target as well

4.Create Source System container

In the DAC, navigate to File > New Source System Container

give Container ID and Name

5.Create Physical and Logical folders

In the DAC, create custom Logical and Physical task folders for the custom folder you created in the Informatica repository.

1. In the DAC, navigate to Tools > Seed Data > Task Logical Folders.


2. To create a custom Logical folder, click New.


3. In the Name field, enter a name for the custom Logical folder, for example, Oracle R12.


4. To create a custom physical folder,navigate to Tools > Seed Data > Task Physical Folders


5. In the Name field, enter a name for the custom Physical folder, for example, ORAR12.

6.Create Logical Data Sources and Task Phase

1. In the DAC, navigate to Tools > Seed Data > Logical Data Sources.


2. To create a custom Logical Data Source, click New.


3. In the Name field, enter a name for the Logical Data Source, for example, OLAP.


4. To create a Task Phase,navigate to Tools > Seed Data > Task Phases


5. In the Name field, enter a name for the Task Phase, for example, Load Dimension.


6. And set the Priority.

7.Register the Physical and Logical Folders in the Source System Folders tab

1. In the DAC, navigate to Design > Source System Folders.


2. Click New.


3. In the Edit child tab, enter the name of the custom Logical folder in the Logical Folder field.


4. Enter the name of the custom Physical folder in the Physical Folder field, and click Save.

8.Import Tables

In DAC,navigate to View>Design>Tables

Right click on the pane and use the option Import from Database to import the source and warehouse tables.

9.Create new tasks for the workflows

1. Navigate to Design > Tasks, and click New in the top pane toolbar.


2. In the Edit child tab, enter the workflow name as it appears in Informatica Workflow Manager.


3. Right-click and select Synchronize Tasks.


4. Select Selected Record Only, and click OK. Click OK in the informational message box.This command synchronizes the source and target table information between the DAC and Informatica.


5. In the Tasks tab, enter the remaining information required for the task.


6. 


7. Click on Save button.

10.Create a Subject Area

1. In the DAC, select the appropriate source system container from the drop-down list in the toolbar.


2.   In the Menu bar, click Views > Design > Subject Areas.


3.   In the top pane toolbar, click New.


4.    In the Edit child tab, enter a name for the subject area, and click Save.


5.   Make sure the new subject area name is highlighted in the top pane, and click the Tables child tab.


6.    Click Add/Remove in the child tab toolbar.


7.    The Choose Tables dialog box opens. The left-hand window lists all the tables held in the selected container.


8.   Query for one or more fact tables.


9.   Select the fact table (use Shift+click to select more than one table), and click Add.


10. The tables are added to the right-hand window, which represents the subject area.


11.    Click OK to close the Choose Tables dialog box.


12. In the top pane toolbar, click Assemble.


13. In the Assembling... dialog box, select Selected Record Only.


14. After assembled, we can see list of tasks which are associated with the added fact tables.

11.Create Execution Plan

In DAC,navigate to Views>Execute>Execution Plans

1. Click New,and give name for EP then click Save


2. To add Subject Area,navigate to child tab  Subject Areas .


3. Add subject area for this EP


4. To setup Connectivity Parameters,navigate to child tab Connectivity Parameters


5. Click on Generate button and set the proper physical data sources for logical data sources.


6. Save Execution Plan

12.Build Execution Plan

In DAC,navigate to Views>Execute>Execution Plans

select the EP and click on Build

this will arrange the tasks in ordered manner.Basically it identifies the dependencies and keeps the tasks in order.

Now DAC configured to start the load,(Click Run Now button to start the Load).