Interested to Buy Any Domain ? << Click Here >> for more details...
major difference between normal loading and bulk loading?
- 6 Answers
- 12354 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
IF WE SELECT THE TARGET LOAD TYPE IS NORMAL, THEN DATA
MOVEMENT IS ROW BY ROW AND STORE AN INSTRUCTIONS IN SESSION
LOG FILE.IF SESSION FAILS, WE CAN RECOVERY THE DATA USING
SESSION RECOVERY AND DATA LOADING IS SLOW. BUT IN BULK TYPE
LOADING DATA IS FAST AND IT DOESN’T MAINTAIN THE SESSION
LOG FILE. IF SESSION FAILS WE CANNOT USE SESSION RECOVERY
IN BULK MODE.
IF I WRONG MEANS PLEASE SEND THE MAIL TO ME
chandranmca2007@gmail.com
| Is This Answer Correct ? | 15 Yes | 0 No |
The major difference is while going with normal load,we can
have session recovery whereas in Bulk loading we can't.
Some of the other differences are as follows:
Normal Bulk
1.Enters session log before 1.Doesn't enter the session
loading into target there by log and loads directly in
increasing the loading time. target there by decreasing
the loading time.
2.Less performance. 2.High performance.
3.Indexing possible. 3.No concept of indexing.
4For small amount of data. 4.For huge amount of data.
Please let me know if you have any further differences.
Thanks.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandrababu.sarupuru
Normal loading will load data row by row and it will create
the datalog for each and every record.
Bulk load will load data in bulk size at a time.It is very
faster than Normal loading .
But in case of session recovery we need data log to recover
the session.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ananta mishra
1-normal loading will load data first in log file then load
in target.
but bulk loading load the data directly in target.
2- performance will increase where bulk loading will use.
3-u can't recover data when use bulk loading.so for that we
have to start workflow again.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ananta mishra
1-normal loading will load data first in log file then load
in target.
but bulk loading load the data directly in target.
2- performance will increase where bulk loading will use.
3-u can't recover data when use bulk loading.so for that we
have to start workflow again.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / seshudwh
in in normal loading: one row complete commit. connect to
tgt table.
bulk loading: first row commit second row........commit all
rows at a time connect to tgt table.
| Is This Answer Correct ? | 0 Yes | 10 No |
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is IQD file?
version controlling in informatica?
To import the flat file definition into the designer where should the flat file be placed?
Hi experts, can anyone tell how much we use plsql in real time
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Why use the lookup transformation ?
What is power play plug in?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
Which is better performance wise database or file?How?
Teradata 
