Alias materialised table names

Answered

Comments

2 comments

  • Comment actions Permalink
    Official comment
    Avatar
    Matthias Korn

    Hi Kenneth, as you are using your BI Frontend directly with the DWH, we agreed on using replication instead of materialization to have named tables that can be conveniently used.

    A general note here: The direct usage of mat_table_x_st_y is not recommended, as the table name will change with each materialization. Please only use the DV views or DV tables and have DV Server as a datasource if you want to use materialized data.

  • 0
    Comment actions Permalink
    Avatar
    Kenneth Chan

    Agree, and being able to write to other DBs definitely helps! https://support.datavirtuality.com/hc/en-us/community/posts/360023830491-Replicating-to-non-DWH-datasources 

Please sign in to leave a comment.

Powered by Zendesk