C2 (2 points)
https://knobit.org/id/task/mm-column-lineage/C2
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/mm-column-lineage/C2 |
| rdfs:label | C2 (2 points) en |
| schema:hasPart | mm-column-lineage C2: view columns resolved to base columns with the view logic |
| schema:identifier | C2 |
| schema:position | 2 |
| schema:text | The view resolved (2 points). CE-131 and CE-132, the columns of mart.v_npl_exposure, feed FINREP but nothing feeds them. Full marks: live column-level edges CE-121 -> CE-131, CE-122 -> CE-131 and CE-121 -> CE-132, each carrying the view's logic from its DDL (npe_amount_eur the SUM of gross_carrying_amount_eur over rows with performing_status 'NPE', gross_loans_eur the SUM over all rows, by reporting date). 1 point if the three edges are drawn with placeholder logic ('view', 'derived'), one of the three is missing, or an edge CE-122 -> CE-132 is added (gross_loans_eur sums every row). Edges from the table CE-120 earn nothing. en |