cimt-ag / data_vault_pipelinedescription

A concept and syntax to provide a universal data format, for storing all essential informations, that are needed to implement or generate a data loading process for a data vault model.
https://www.cimt-ag.de/leistungen/data-vault-pipeline-description/
Apache License 2.0
5 stars 0 forks source link

Rewrite Tests 5xxx #291

Closed mattywausb closed 4 months ago

mattywausb commented 5 months ago

There was a misunderstanding about the syntax for the 5xx cases.

The must be only one Dependent Child key column in the link. not three. Result for the Link must be like: rtjj_501_aaa_bbb_dlnk (lnk) [.rvlt_test_jj.rtjj_501_aaa_bbb_dlnk] meta_load_date | MD_INSERTED_AT TIMESTAMP meta_load_process_id| MD_RUN_ID INT meta_record_source | MD_RECORD_SOURCE VARCHAR(255) parent_key | HK_RTJJ_501_AAA CHAR(28) parent_key | HK_RTJJ_501_BBB CHAR(28) key | LK_RTJJ_501_AAA_BBB CHAR(28) dependent_child_key | F9F10F11_AAA_BBB_DC1F VARCHAR(255)

This is achieved by injecting every relation name in the following manner (Example from 501, already changed in branch "mawegner")

,{"field_name": "F9XX_AAA_BBB_DC1F_TTT", "field_type": "VARCHAR(255)", "field_value":"TTT" , "targets": [{"table_name": "rtjj_501_aaa_bbb_dlnk","column_name":"F9F10F11_AAA_BBB_DC1F" ,"relation_names":["TTT"]} ]} ,{"field_name": "F10_AAA_BBB_DC1F_UUU", "field_type": "VARCHAR(255)", "field_value":"UUU" , "targets": [{"table_name": "rtjj_501_aaa_bbb_dlnk","column_name":"F9F10F11_AAA_BBB_DC1F" ,"relation_names":["UUU"]} ]} ,{"field_name": "F11_AAA_BBB_DC1F_VVV", "field_type": "VARCHAR(255)", "field_value":"VVV" , "targets": [{"table_name": "rtjj_501_aaa_bbb_dlnk","column_name":"F9F10F11_AAA_BBB_DC1F" ,"relation_names":["VVV"]} ]}

Please adapt all 5xx cases to that pattern