DAC Configuration_Part3

10.Define the Server Port in Integration services Custom Properties:

        Go to Integration Services (Integration_Service) -->Properties-->Custom Properties-->New

Name: ServerPort

Value: 4006

 Now Restart the DAC Server and client,login to DAC client.

11.Configuring Informatica connections in DAC:

To Configure Informatica Server in DAC:

Go to DAC Setup InformaticaServersNew

        Select “Informatica” in Type drop box and Enter the following values (look into the admin console for these details) and “Test Connection”.

 

To Configure Repository server in DAC:

              Go to DAC SetupInformaticaServersNew

               Select “Repository” in the Type drop down list

  

12.Configuring Database connections in DAC:

                 Configure Physical Data Sources in DAC :OLAP

                 Create User in the Database for the Target (Data warehouse)

 

 

 

 

13.Creating Warehouse Tables:

        For This First You Need to Create a ODBC Connection for DWH user,and Then....