Data_Transfer and Database size.

[former_member221211]

Hello all,

I am using a Data_Transfer transform to speed up job performance. My question is that if I use these transforms will database size increase by a larger percentage than if not using it. And if so are there options that I can select to limit the size in growth in Data Services and in the Database? The database that is being used is Oracle 11g.

Thank you

[former_member200473 · Accepted solution]

Hi Vitali,

Data_transfer Transform will create virtual table which removed/drop after the transfer is done ( but for the transfer time it consumes space/size ).

Thanks & Regards,

Shiva Sahu

[former_member221211 · Accepted solution]

Hi Shiva,

Thank you for your response. Just to make sure I understand you mean that after the job is done, whatever temp tables are creating during the "Data_Transfer" are removed from the database and will not take up space? Also does using this method increase the database log size much more than just using a DS job without it?

Thank you and sorry for all the questions.

[Former Member · Accepted solution]

Hi,

Yes, the table is generated only at run time and increases the log size. This is just like any other table that is created on the database.

If do not have a DS job without it then DS all resource intensive operations will consume memory.

Arun