Question { HP, 6200 }

I have source like this 1:2;3. so i want to load the target
as 123

Answer

Im don't think Replace function would work ..
We have replacechr and replacestr functions instead.
try this ..

REPLACESTR(1,'1:2;3',':',';','')

should work fine.

Question { 5109 }

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

Answer

For History Load, generally the data is bulk loaded because the cost of indexes on the table is skipped when bulk loading is done as indexes on the target table are not allowed for bulk load.Once the data is loaded then the indexes are created. This way we could load the data into the target much faster.Also bulk load would not write the rows in the roll back segment.The time taken to write into roll back segment is also saved.Hence performance improved.