I'm working on an scd transformation,there I have to load more than 500 thousand records.But during run time it takes more than half an hour to load the data.I increase the size in the Miscellanious field and increase the commit size.But still it take too much time.

Please anyone give me a solution ASAP.

Thanking You.