Dynamic Table Creation

This option allows you to create a new table on the fly if the target Information Domain of the Data Mapping is based on the HDFS database. You can use the newly created table for mapping. The newly created table will be part of the OFSAAI Data Model, and it is made visible and available to all other modules.

Note that you cannot create a table with partition.

To dynamically create a table follow these steps:

1. From the DI Mapping window, click in the Target Entities pane.
   The Create Table window is displayed.
2. Enter a table name and click Generate.
   The new table name is displayed on the Target Entities pane.
3. Select the required attributes from the Definition pane and map them to the new Table in the Target Entities pane by clicking the button.
4. After defining all mappings, click Save. The table will be created in the HDFS/ HIVE system with the structure/data types of the mapped columns, and it will be added to the metadata repository (both database xml and the object registration tables). The newly created table will be available for use in other metadata like Datasets, Hierarchies, and so on.