T_CNTRY_E

This transformation scheme adds information from the cube [simple_tooltip content='EXTRNL_CRDT_ASSSSMNT; All external credit assessments used in input cubes must be registered in this cube.']External credit assessments[/simple_tooltip] to the cube [simple_tooltip content='CNTRY; It contains reference information for countries. All countries used in input cubes must be registered in this cube.']Countries reference information[/simple_tooltip].

Scheme dependencies:

Transformation Scheme ID

T_CNTRY_E

Description

Countries reference information enriched input layer

Classification

Phase Type Subtype Related entity
Enrichment Technical Other

Natural language

This transformation scheme adds information from the cube External credit assessments to the cube Countries reference information.

Scheme dependencies:

VTL Syntax

0 CNTRY_E := [inner CNTRY as "A", EXTRNL_CRDT_ASSSSMNT as "B" on A.EXTRNL_CRDT_ASSSSMNT = B.EXTRNL_CRDT_ASSSSMNT] {keep (A.CNTRY, B.CRDT_QLTY_STP, A.CRRNCY, B.ECAI_ECA, B.EXTRNL_CRDT_ASSSSMNT, A.IS_MMBR_STT, B.IS_SHRT_TRM_CRDT_ASSSSMNT)};
1 CNTRY_E := CNTRY_E [keep (CNTRY, CRDT_QLTY_STP, CRRNCY, ECAI_ECA, EXTRNL_CRDT_ASSSSMNT, IS_MMBR_STT, IS_SHRT_TRM_CRDT_ASSSSMNT)];