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
I mean - any of 3 samples
- tHashOutput / tHashInput
collect(accumulate) means store somewhere - file, database or memory, so and components must be related
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Learn how to use an API-First Approach to Modernize your Applications