Skip to main content
Solved

Why Trigger tables?

  • June 9, 2022
  • 2 replies
  • 18 views

Forum|alt.badge.img+5

I am not able to interpret why trigger tables are used. Data that will be extracted on real time, doesn't it automatically be refreshed in all tables?

Best answer by burim.hoxha

Hello Raman,

thank you for your question.

 

Real Time Transformations are executed each time new records are extracted to a specific table. This means that you need to map each transformation statement to a table whose extraction should trigger the transformation. This table is called a Trigger Table. In the Replication Cockpit, transformations are always defined at table-level.

 

You may find more information here: Introducing Trigger Tables

2 replies

  • Celonaut
  • Answer
  • June 12, 2022

Hello Raman,

thank you for your question.

 

Real Time Transformations are executed each time new records are extracted to a specific table. This means that you need to map each transformation statement to a table whose extraction should trigger the transformation. This table is called a Trigger Table. In the Replication Cockpit, transformations are always defined at table-level.

 

You may find more information here: Introducing Trigger Tables


Forum|alt.badge.img+5

Hello Raman,

thank you for your question.

 

Real Time Transformations are executed each time new records are extracted to a specific table. This means that you need to map each transformation statement to a table whose extraction should trigger the transformation. This table is called a Trigger Table. In the Replication Cockpit, transformations are always defined at table-level.

 

You may find more information here: Introducing Trigger Tables

That made it clear, thank you