Accumulation and Batch updatein Oracle

[Anonymous]

I have use case ..wherein

1. i need to query records from a table A

2.iterate those records on table B to fetch more data

3.Accumulate all the data fetched from Table B.

4.Batch insert/update Accumulated data in another table C .

For this kindly help with components

TDbinput(A)--->tflowtoIterate --->TDbinput(B)-->>tflowtoIterate--> ?? How to accumulate data and batch update table (C) at one go only

[vapukov]

Hi,

• write to local CSV file
• write to staging table on target server
• store in memory hash (tHashOutput / tHashInput)

[Anonymous]

Can u share the list of components that need to be used to achieve this 

[vapukov]

Hi,

I mean - any of 3 samples

- tFileOutputDelimited

- tDBOutput

- tHashOutput / tHashInput

collect(accumulate) means store somewhere - file, database or memory, so and components must be related