topic Re: Inserting data into a table all at once in Dataflux in SAS Data Management

Inserting data into a table all at once in Dataflux

maxd — Thu, 19 Jul 2018 14:03:47 GMT

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.

Re: Inserting data into a table all at once in Dataflux

audrey — Thu, 19 Jul 2018 14:14:50 GMT

Hi,

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

Cheers,

Audrey

Re: Inserting data into a table all at once in Dataflux

maxd — Thu, 19 Jul 2018 15:04:53 GMT

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.

Re: Inserting data into a table all at once in Dataflux

maxd — Thu, 19 Jul 2018 15:08:56 GMT

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