Better way to handle bulk load to database and also can resolve the memory issue

[Anonymous]

Before we load data into database, we can use tmap => dboutput

in the tMap we have store on disk option, and we can choose partitions , we need to configure one folder in the server, than load into Database

This also solves the memory issues in the job and improves performance

[vapukov]

Hi!

welcome to the community! it is great when people shared their experience!

but better to do this in the form which not ambiguous (same as at least 2 other from you)

any beginner users will start a search from here and it will be good to have really best practice only.

.regards, Vlad