Looking for Information on Bulk Load in BODS Vs Netezza DB

[Former Member]

Hi All,

Pre-Info:

We are using BODS V4.2  and Netezza as Data mart. We have used Bulk Load option while loading data to Data Mart..

Current Scenario:

Due to Bulk load options enabled in DS, every time it is increasing the OID objects in Netezza and currently we are going to reach the MAX(OID's) in Netezza.

Is there any one faced this kind of issue? If yes, Please let me know how can we avoid this from BODS perspective and looking for different option \ solution on the same.

Also, other than Bulk Load option is there any way which would increase the performance at the same time cann't create object in Netezza and don't want to increase the OID counts.

Appreciate earlier reply on this.

Regards,

Ganesh N.

C: 203-219-8889

[Former Member]

Hi,

While loading data in data mart, are you maintaining any SCD.

You can use table comparison in your case to avoid huge records to be inserted into target.

Thanks,

Swapnil