• It is possible with trigger right?

    But, warehouse data need not be up-to-date with OLTP data right?