major difference between normal loading and bulk loading?

Answers were Sorted based on User's Feedback



major difference between normal loading and bulk loading?..

Answer / chandrasekar

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

major difference between normal loading and bulk loading?..

Answer / james

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

major difference between normal loading and bulk loading?..

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

major difference between normal loading and bulk loading?..

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

major difference between normal loading and bulk loading?..

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

major difference between normal loading and bulk loading?..

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

Post New Answer

More Informatica Interview Questions

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


How does a rank transform differ from aggregator transform functions max and min?

0 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


What is DR strategy for Informatica project?

0 Answers  


My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,






What is the use of source qualifier?

0 Answers  


which one is better performance wise joiner or look up

0 Answers   Informatica,


How to delete the data in the target table after loaded.

3 Answers   TCS,


What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,


What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


What are mapping parametres and variables in informatica?

6 Answers   TCS,


Categories