Skip to Content

8. Date_Generation Transform:

Produces a series of dates with a specified increment

From this generated sequence we can populate other fields in the time dimension (Such as day_of_week) using functions available in the query

Data Inputs – none

Data Outputs – A data set with a single column named DI_GENERATED_DATE  containing the date sequence

In the Date _generation editor the following details are to be provided.

           Start date

            End date

            Increment value

/wp-content/uploads/2014/02/1_390438.jpg


/wp-content/uploads/2014/02/1_390438.jpg


9. Hierarchy Flattening Transform:

The hierarchy flattening transform can analyze a parent-child relationship and provide a description of the hierarchy in a flattened format (vertically flattened/ horizontally flattened). 

Each row in the output will contain 1 parent-child relationship.

If we had additional columns in the source table , that are associated with the Parent column, we could have added them to the Parent attribute List.

Similarly , if we had additional columns in the source table , that are associated with the Child column, we could have added them to the Child attribute List

consider the following reporting structure in an organization:

/wp-content/uploads/2014/02/1_390438.jpg



Hierarchy Flattening Vertical:

/wp-content/uploads/2014/02/1_390438.jpg

/wp-content/uploads/2014/02/1_390438.jpg


Hierarchy Flattening Horizontal:

/wp-content/uploads/2014/02/1_390438.jpg

/wp-content/uploads/2014/02/1_390438.jpg


10. Validation Transform:

Qualifies a data set based on rules for input schema columns. Allows one validation rule per column.

Filters out or replaces data that fails the criteria

Outputs two schemas: Pass and Fail. The Pass output schema is identical to the input schema. It also adds two columns to the Fail output schema:

DI_ERRORACTION

DI_ERRORCOLUMNS

The DI_ERRORACTION column indicates where Failed data was sent:

B for “sent to both Pass and Fail outputs”

F for “sent only to the Fail output”

The DI_ERRORCOLUMNS column displays all error messages for columns with failed rules.

/wp-content/uploads/2014/02/1_390438.jpg

/wp-content/uploads/2014/02/1_390438.jpg

/wp-content/uploads/2014/02/1_390438.jpg

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Shaan S

    Hi,

    I have read your first part and missed out remaining parts..Am going through remaining documents now..Your information really helped me..Thanks for the work..

    Regards,

    Shaan..

    (0) 

Leave a Reply