major difference between normal loading and bulk loading?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between a data warehouse and a data mart?

600


What is the commit type if you have a transaction control transformation in the mapping?

656


Define joiner transformation?

598


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1690


Why union transformation is an active transformation?

659






What does “tail –f” command do and what is its use as an Informatica admin.

635


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1878


How many number of sessions can one group in batches?

698


How many numbers of sessions can one group in batches?

625


Define mapplet?

627


What is InformaticaPowerCenter?

694


Differentiate between source qualifier and filter transformation?

1003


What are the different lookup cache(s)?

622


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6094


What are the static cache and dynamic cache in informatica?

722