Script ODS

[houssem_temimi1]

hello experts

When I check the table "ODS_EXTRACT_CONTROL_DATE" I see a several lines for each table name in the same extract_date_time

see joint pce

Is it a correct beahviour?

thank you

extract_log_date.txt.zip

[stuarta1]

This is correct - each record is for a particular extract or summary, so the TRANS_TYPE is different.

For example TRANS_TYPE 1=inserting to the temp table, 2=transforming to the detail table, 3 onwards are for summaries and the letters are for the Global ODS, which you are not using.

Stuart.

[sergiy_katerinich]

Hi!

Looks fine to me.

The only thing to check is that after complete of ODSProductionLog script, PRODUCTION_LOG 4 to 7 should have the same timestamp as PRODUCTION_LOG 1 to 3 have. I guess you just took the snapshot while this script was running.

Regards,

Sergiy