Data Model

[santharubban]

Hi All,

I am facing a data model issues, there 2 different data sources in which one data source have structure of genealogy and other data source have its relative information. Now I want to join these 2 data source take details of each genealogy details, can anyone help on same. For reference I have attached the sample excel with 2 different data source and   its output.

[santharubban]

Stages are nothing but Batching, for each stage I need to provide the relative data from the 2nd data sources without breaking genealogy structure. can any help me out on same.

[Gysbert_Wassenaar · Accepted solution]

Something like this:

AST:

MAPPING LOAD BATCH, ACT_START_DATE FROM ....

AFT:

MAPPING LOAD BATCH, ACT_FINISH_DATE FROM ....

QRD:

MAPPING LOAD BATCH, QA_RELEASE_DATE FROM ....

LOAD 

STAGE_1_BATCH

applymap('AST',STAGE_1_BATCH) AS STAGE_1_ACT_START_DATE

applymap('AFT',STAGE_1_BATCH) AS STAGE_1_ACT_FINISH_DATE

applymap('QRD',STAGE_1_BATCH) AS STAGE_1_QA_RELEASE_DATE

STAGE_2_BATCH

applymap('AST',STAGE_2_BATCH)  AS STAGE_2_ACT_START_DATE

applymap('AFT',STAGE_2_BATCH)  AS STAGE_2_ACT_FINISH_DATE

applymap('QRD',STAGE_2_BATCH)  AS STAGE_2_QA_RELEASE_DATE

STAGE_3A_BATCH

applymap('AST',STAGE_3A_BATCH)  AS STAGE_3A_ACT_START_DATE

applymap('AFT',STAGE_3A_BATCH)  AS STAGE_3A_ACT_FINISH_DATE

applymap('QRD',STAGE_3A_BATCH)  AS STAGE_3A_QA_RELEASE_DATE

STAGE_3B_BATCH

applymap('AST',STAGE_3B_BATCH)  AS STAGE_3B_ACT_START_DATE

applymap('AFT',STAGE_3B_BATCH)  AS STAGE_3B_ACT_FINISH_DATE

applymap('QRD',STAGE_3B_BATCH)  AS STAGE_3B_QA_RELEASE_DATE

STAGE_4_BATCH

applymap('AST',STAGE_4_BATCH)  AS STAGE_4_ACT_START_DATE

applymap('AFT',STAGE_4_BATCH)  AS STAGE_4_ACT_FINISH_DATE

applymap('QRD',STAGE_4_BATCH)  AS STAGE_4_QA_RELEASE_DATE

STAGE_STAGE_5_BATCH

applymap('AST',STAGE_STAGE_5_BATCH)  AS STAGE_STAGE_5_ACT_START_DATE

applymap('AFT',STAGE_STAGE_5_BATCH)  AS STAGE_STAGE_5_ACT_FINISH_DATE

applymap('QRD',STAGE_STAGE_5_BATCH)  AS STAGE_STAGE_5_QA_RELEASE_DATE

FROM ...