SCD Execution for Heterogeneous Support

Assumptions:
  1. The DIM table in Hive and RDBMS should have the same table and column names, though column order may differ but not the data type.
  2. You need to log into the ICC/ RRF Pages from the source Infodom, that is, Hive Infodom.
  3. You need to pass two additional parameters DBSERVERNAME and DBSERVERIP while invoking the SCD using the Run Executable component.
    For SCD execution from Operations (ICC) module, the Executable format is as follows:
    <SCD EXECUTABLE NAME>,<REFRENCE NUMBER>,<TARGET RDBMS NAME>,<TARGET RDBMS SERVER>
    For example: scd,78,ofsaatm,192.168.1.0
    From RRF, specify Parameters in the format:
    “<SCD EXECUTABLE NAME>”,”<REFRENCE NUMBER>”,”<TARGET RDBMS NAME>”,”<TARGET RDBMS SERVER>”
    For example: “scd”,”78”,”ofsaatm”,”192.168.1.0”