CODEWITHSUNDEEP
parallel-processingbulk-loadoracle-data-integrator
user3296816
user3296816

Reputation: 1

How to avoid concurrency error for multiple files loading into a single table in ODI 12c

I have a scenario where there are 3 files of 5 million lines each with 3 weeks of data is bulk mapped to a staging table. They run parallelly. If the data transfer for a file fails with a concurrency error, what will be the best way to load the data of the 3 files effectively into the stage table. (I was asked this in an interview.)

Upvotes: 0

Views: 526

Answers (1)

JeromeFr
JeromeFr

Reputation: 1928

In ODI 12c, Parallel Target Table Load can be achieved by selecting the Use Unique Temporary Object Names checkbox in the Physical tab of a mapping. The work tables for each concurrent session will have a unique name.

I discuss it in more details in the Parallel Target Table Load section of this blog on ODI 12c new features

Upvotes: 0

Related Questions