scd type 2 table does not load more that 10 k rows at a time

Anonymous — Sat, 06 Oct 2018 14:53:23 GMT

hello everyone,

In my scenario i want to create a type 2 table by using manual update/insert code, source is input mysq l, target is also mysql db,

when i m loading 1 lakh data at a time, it can load only 10K rows, then the process are not increase .

Please suggest as to how I can go about this?

Thanks,

Manish

Re: scd type 2 table does not load more that 10 k rows at a time

Anonymous — Sat, 06 Oct 2018 17:47:06 GMT

Are you getting error? If so, what? If not, does it carry on if you leave it for a long time? If that is the case, you might want to try indexing