Create datastores

 

Create datastore statement is similar to a CREATE TABLE SQL statement. The statement for the creation of an ODI datastore corresponding to a file might look like the one below. Keywords like ALIAS, RESOURCE correspond to datastores properties in ODI.

 

A datastore corresponding to an Oracle table can be created using the following statement:

 

It is possible to create more complex ODI datastores for example datastores corresponding to fixed record length files, SCD tables, etc. A statement that creates an ODI datastore of SCD type is shown below: