DAC Tasks & Explanation

Step	Task Name	Descriptiopn	Notes
1	Seed Data Configuration	a) Task Logical folders	One Time Only. This is to be done when a new Informatica Folder is created.
		b) Task Physical Folders	One Time Only. This is to be done when a new Informatica Folder is created.
		c) Task Phase – Optional	One Time Only. This is to be done when a new Informatica Folder is created.
2	Source Folder Relationship	In the Design under Source System Folders tab, link the Task Logical folders and Task Physical Folders	One Time Only. This is to be done when a new Informatica Folder is created.
3	Import Table/s	In the Design view under Tables Tab, import the new fact or dimension table by right clicking in the work space. This will show a list of tables and select the table that you want to import.	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
4	Import Columns for the custom table/s	Right click on the custom table imported in step 3 and select Import > Database columns. This imports all of the columns for the particular table. If it is a fact table under the columns sub-tab make sure to enter the Foreign Key table and Foreign Key. (This is a very important step)	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
5	Create Task	In Design view under Task Tab, click New. Create a new Task. Enter the all of the required details in the Edit Subtab. Make sure to enter the correct Workflow names for Full and Incremental loads. Select the correct Logical folder name from the drop down. Also, select the correct source and target connections for the task. Default Source = DBConnection_OLTP and Target = DBConnection_OLAP	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
6	Synchronize the Task	Right click on the Task that you created in Step 5 > Select Synchronize task. In the pop-up window select the option for the Selected Task Only. This should synchronize the DAC Task with your Informatica task and the Source and Target tables are filled out for the Task	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
7	Update the Source and Target table options	After you perform Step 6, click on the Sources subtab and enter the required details. Make sure to enter the Source connection value which is always DBConnection_OLTP.                                   Repeat the above step for the target table. Select the truncate for Full load or Truncate always option. Make sure to enter the Target connection value which is always DBConnection_OLAP	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
8	Update the newly imported tables	In the Design view under Tables Tab, identify all of the tables including source and targets that got imported from Step 6 and update the correct Table type values.	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
9	Import Indexes	In the Design view under Tables Tab, identify all of the tables that you created in Step 6 and right click and import all the indexes. The prerequisite for this is the index has to be created on the tables at the database level.	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
10	Set Index Properties	Once the Indexes have been imported in Step 9, click Indexes Tab in the Design View and identify all the indexes you just imported and set the correct value. Make sure to set it as an ETL or a query index.  Also, set the Drop and recreate bit map indexes always option so that the indexes are always dropped and recreated for Full load.	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
11	Create Subject Area	In Design View > Subject Area Tab, click new. Enter a name for your subject area. Click Save. Click on the Tables subtab and add the fact table/s for the star or subject area that your are building. Click Save.	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema)
12	Assemble the Subject area	Once the Subjecta area is built as in Step 11, click on the Assemble button to create a list of all Tasks for that subject area. This will prompt you for the selected or all records option and make sure to select select record only. If you are assmebling more than one SA, then select the other option. For this step to happen correctly, Steps 4, 5 & 6 needs to be completed accurately.	Everytime you Add a new Dimension (Extending an existing Star or Custom Star) or Fact table (a new Star Schema). When ever you add delete or Modify any Tasks or related objects Assemble the Subject Area. Advisable to perform this step on changes to any of the DAC objects.
13	Create New Execution Plan	In Execute View, click on New. Enter a Name for the Execution Plan. Click Save.	When you create a new Execution Plan
14	Add the Subject area	Cick on the Subject Area subtab under Execute View > Add the new Subject Area configured in Step 11 and 12. Click Save	When you create a new Execution Plan or Modify an existing one to add or remove Subject Areas
15	Generate Parameters	Cick on the Parameters subtab under Execute View > Click Generate. Select 1 from the pop-up window. Once the parmeters are generated, select appropriate values for the DataSources. Validate the Folder assignment which happens by default. Click Save	When you create a new Execution Plan or Modify an existing one to add or remove Subject Areas
16	Build the Execution Plan	In Execute View > Execution Plan, Select the execution Plan created and configured in Step 13,14,15. Click Build. This will prompt you for the selected or all records and make sure to select select record only. Complete a series of prompts and wait for the Execution Plan to be Built. Your execution plan is ready to be Run!	When ever you add delete or Modify any Tasks or related objects. Advisable to perform this step on changes to any of the DAC objects.