Temporary Target Datastore in odi

Temporary Target Datastore

To add a temporary target datastore:

1. In the Target Datastore panel, select the title of the target datastore <Temporary Target Datastore> to display the Property Inspector for the target datastore.
   
2. On the Diagram Property tab of Property Inspector, type in a Name for this datastore.
   
3. Select the Context for this datastore if you want to target this datastore in a predefined context. By default, the datastore is targeted on the context into which the interface is executed. This is an optional step.
   
4. Specify the Temporary Datastore Location. Select Work Schema or Data Schema if you wish to create the temporary datastore in the work or data schema of the physical schema that will act as the staging area.The temporary target datastore will be created only if you activate the IKM option CREATE_TARG_TABLE when defining the flow.
   
   
5. Go to the Overview tab and select the logical schema into which this temporary target datastore is created.
   

The temporary target datastore is created without columns. They must be added to define its structure.
To add a column to a temporary target datastore:

1. In the Target Datastore panel, right-click the title bar that shows the name of the target datastore.
   
2. Select Add Column.
   
3. A new empty column appears in the Target Datastore panel. Select this new column.
   
4. In Diagram Property tab of the Target Mapping Property Inspector give the new column definition in the Target Column field group. You must define the column Name, Datatype, Length and Scale.
   

To delete a column from a temporary target datastore:

1. Right-click the column to be deleted In the Target Datastore panel.
   
2. Select Delete.
   

To add one or several columns from a source datastore to a temporary target datastore:

1. Add the source datastore as described in
   
2. In the Source Diagram, select the source datastore columns you wish to add.
   
3. Right-click and select Add Column to Target Table.
   
4. The columns are added to the target datastore. Data types are set automatically.
   

To add all of the columns from a source datastore to a temporary target datastore:

1. Add the source datastore.
   
2. In the Source Diagram, select the title of the entity representing the source datastore.
   
3. Right-click and select Add to Target.
   
4. The columns are added to the Target Datastore. Data types are set automatically.