Informatica - When do you use Normal Loading and the Bulk Loading, Tell the difference?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 558 of 631

When do you use Normal Loading and the Bulk Loading, Tell the difference?

Total Answers and Comments: 3

Last Update: July 24, 2008 Asked by: Thejaswini

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 19, 2007 11:35:05

rama krishna

RE: When do you use Normal Loading and the Bulk Loadin...

If we use SQL Loder connectionsÂ then it will be to go for Bulk loading. And if we use ODBC connections for source and target definations then it is better to go for Normal loading.
If we use Bulk loading then the session performence will be increased.
how means... if we use the bulk loading, the data will be BYPASS through the DATALOGS. So automatically performence will be increased.

Is this answer useful? Yes | No

September 28, 2007 10:42:18

chandrarekha

RE: When do you use Normal Loading and the Bulk Loadin...

Normal Load: It loads the records one by one, Server writes log file for each record, So it takes more time to load the data.

Bulk load : It loads the number of records at a time, it does not write any log files or tracing levels, so it takes less time.

Is this answer useful? Yes | No

July 24, 2008 09:51:35

vivekvish

Member Since: July 2008 Contribution: 1

RE: When do you use Normal Loading and the Bulk Loading, Tell the difference?

You would use Normal Loading when the target table is indexed and you would use bulk loading when the target table is not indexed. Running Bulk Load in an indexed table will cause the session to fail.

Is this answer useful? Yes | No

Go To Top