SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Inserting data into a table all at once in Dataflux

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Inserting data into a table all at once in Dataflux

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.

 


Accepted Solutions
Solution
4 weeks ago
SAS Employee
Posts: 27

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

Hi,

 

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

 

Cheers,

Audrey

View solution in original post


All Replies
Solution
4 weeks ago
SAS Employee
Posts: 27

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

Hi,

 

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

 

Cheers,

Audrey

Occasional Contributor
Posts: 5

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

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.

Occasional Contributor
Posts: 5

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 119 views
  • 0 likes
  • 2 in conversation