topic Re: Accumulation and Batch updatein Oracle in Talend Studio

Accumulation and Batch updatein Oracle

Anonymous — Sat, 16 Nov 2024 06:02:25 GMT

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 — Sat, 20 Apr 2019 10:38:49 GMT

Hi,

Anonymous — Sat, 20 Apr 2019 14:37:05 GMT

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

vapukov — Sat, 20 Apr 2019 14:39:37 GMT

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