Inserting data into a table all at once in Dataflux

[maxd]

Hello,

Currently, I have a job that inserts data into a Teradata table one row at a time via a Data Target (Insert) node. Is it possible to insert the data in chunks or all at once?

I've tried creating a process job with two Data Job (reference) nodes. One node inserts the data into a text file then the other node takes that data and inserts it into a table all at once. But, I'm getting error 43: Data flow - Invalid parent slot. I believe it's because the Data Target (Insert) node isn't getting an input.

[audrey · Accepted solution]

Hi,

Did you try to change the Options in the Data Target node to Commit all rows in a single transaction?

Cheers,

Audrey

[maxd]

I selected commit all rows in a single transaction. However, it's still performing 1 transaction at a time from what I can see querying the table during the data job. Also, the status of the data job is slowly incriminating the number of rows inserted.

[maxd]

I forgot to change the Bulk row count from 1 to 1000 (or another number). Thank you for your help!