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
Copy input row
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.