Is there such thing as bulk select and insert in DataStage? I have something like:
Code: Select all
SELECT from remote DB --> transformer --> INSERT to DW
Thanks in advance.
Moderators: chulett, rschirm, roy
Code: Select all
SELECT from remote DB --> transformer --> INSERT to DW
You could trick it like this:laiko wrote:Hi,
Is there such thing as bulk select and insert in DataStage? I have something like:I noticed that the records are one by one going through the transformer, then to INSERT stage. I find this very slow. Is it possible to bulk colelct them before inserting? There's no stage variables also in my transformer, just TRUNC functions.Code: Select all
SELECT from remote DB --> transformer --> INSERT to DW
Thanks in advance.
Code: Select all
SELECT from remote DB --> Sequential stage -->transformer --> INSERT to DW