Assumptions

DIM table in Hive and RDBMS should have the same table and column names, though column order may differ but not the data type.

User needs to pass two extra parameters DBSERVERNAME and DBSERVERIP in SCD call to update data from Hive to RDBMS. This is done using RUN EXECUTABLE.

<SCD EXECUTABLE NAME>,<REFRENCE NUMBER>,<TARGET RDBMS NAME>,<TARGET RDBMS SERVER>

For example:

scd,78, devofsatm,192.0.2.1

Relevant entry should be present in AAI_DB_DETAIL table corresponding to <TARGET RDBMS SERVER> and <TARGET RDBMS NAME>.