How can we Save Bulk Records post RDB List

User Experience
, ,
1

Hi All,

Have fetched the records using RDB List as the query is complex, now need to save bulk records say a 100K to a spine table.

How can we achieve it efficiently?

Any suggestion would be helpful.

Thanks!

Priyesh A

2

@Priyesh

Leverage a data flow to save the records to target table efficiently.

3

@SriHarsha Anika Thanks for the Response.

I have an activity in the data flow, which is calling RDB-List and getting the results in a page.

Is there a way to get that page back to dataflow primary page and process in data flow further?

if not, we need to save the records in activity itself? by calling RDB-Save or “Call Save” (which saves one by one)?

Thanks!

Priyesh A

4

@Priyesh

I think the best bet would be to Call Save and perform commit in batches (100 records or so).