Patent ID: 11966409
Assignee: ORACLE INTERNATIONAL CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. A system, comprising:
memory storing computer-executable instructions; and
one or more hardware processors that access the memory and perform the computer-executable instructions to at least:
reserve, in a data warehouse table, a first set of extension columns, the data warehouse table containing a plurality of initial columns;
receive metadata from a customer source, the metadata identifying an attribute for the data warehouse table;
extract the attribute from the metadata;
determine that the attribute from the metadata does not correspond to a column of the plurality of initial columns in the data warehouse table;
responsive to determining that the attribute does not correspond to a column of the plurality of initial columns, compare a data type corresponding to the attribute from the metadata of the customer source to a data type of a next unallocated column in the first set of extension columns from the data warehouse table;
based at least in part on the instructions to compare, select the first set of extension columns in the data warehouse table for mapping based at least in part on the next unallocated column having:
(a) matching metadata code indicating matching column properties between a source property corresponding to the attribute and a target property corresponding to the next unallocated column; and
(b) a match between the data type of the next unallocated column in the first set of extension columns and the data type corresponding to the attribute;
generate code to map the attribute to the next unallocated column based at least in part on the metadata from the customer source;
map the attribute to the next unallocated column based at least in part on the generated code; and
execute instructions to move data associated with the attribute into the next unallocated column of the data warehouse table.