DSXchange

Hi,
We have a one single row from source table as a daily record, how to make 24 identical rows as input to target table, which requires data showing like hourly.


Thanks,

Yan

Welcome aboard.

The easiest is to use a Copy stage or a Transformer stage with 24 outputs. Use a Copy stage if there are no columns to be added; use a Transformer stage if there are.

You could bring all 24 links back together using a Funnel stage, or - if the time is a key column in the target table, simply run 24 concurrent sets of (distinct) inserts.