diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-08-21 11:39:09 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-08-21 11:39:09 +0700 |
| commit | fe6a7e1fd2c25c5610c35dae8d8697f93d51042d (patch) | |
| tree | 39560398339feb1ca561b8fbe5bf1a23c15d8cd8 /refresh_materialized_view.ktr | |
| parent | f631e7a268d66e7565d158c011793b7f711257d9 (diff) | |
refresh materialized view leadtime
Diffstat (limited to 'refresh_materialized_view.ktr')
| -rw-r--r-- | refresh_materialized_view.ktr | 49 |
1 files changed, 46 insertions, 3 deletions
diff --git a/refresh_materialized_view.ktr b/refresh_materialized_view.ktr index 1440237..63164f0 100644 --- a/refresh_materialized_view.ktr +++ b/refresh_materialized_view.ktr @@ -562,6 +562,11 @@ <to>aging customer</to> <enabled>Y</enabled> </hop> + <hop> + <from>aging customer</from> + <to>leadtime so to delivered</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>accurate</name> @@ -640,6 +645,44 @@ </GUI> </step> <step> + <name>aging customer</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <execute_each_row>N</execute_each_row> + <single_statement>N</single_statement> + <replace_variables>N</replace_variables> + <quoteString>N</quoteString> + <sql>refresh materialized view mv_aging_customer</sql> + <set_params>N</set_params> + <insert_field/> + <update_field/> + <delete_field/> + <read_field/> + <arguments> + </arguments> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>624</xloc> + <yloc>432</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>combine</name> <type>ExecSQL</type> <description/> @@ -1134,7 +1177,7 @@ </GUI> </step> <step> - <name>aging customer</name> + <name>leadtime so to delivered</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -1149,7 +1192,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_aging_customer</sql> + <sql>refresh materialized view mv_leadtime_so_to_delivered</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -1166,7 +1209,7 @@ </output> </remotesteps> <GUI> - <xloc>624</xloc> + <xloc>800</xloc> <yloc>432</yloc> <draw>Y</draw> </GUI> |