Data source/GB-EAW.CR/data model/Company/Accounts.LastMadeUpDate/mapping/CDQ/transformation

From CDQ
Jump to navigation Jump to search


Part of Hierarchical relation between two concepts of the CDQ Data Model. Data source GB-EAW.CR
Mapping source The source of a data model mapping. Data source/GB-EAW.CR/data model/Company/Accounts.LastMadeUpDate/mapping/CDQ
Transformation type A type of a transformation applied to a data model mapping. CUSTOM_TRANSFORMATION"CUSTOM_TRANSFORMATION" is not in the list (UPPER_CASE, LOWER_CASE, CUSTOM) of allowed values for the "Has transformation type" property.
Transformation parameter A transformation parameter is an action proccessed by a data model transformation. n/a
Description Informal and comprehensive human-readable definition of a concept. n/a

Transformation code Any code (in Python, JAVA or other) that will transform values for a given data source attributes.

import datetime


def transform(raw_data):

    year = int(raw_data[6:10])
    month = int(raw_data[3:5])
    day = int(raw_data[:2])
    d = datetime.datetime(year, month, day)

    return d.strftime('%Y-%m-%dT%H:%M:%S.00Z')