major difference between normal loading and bulk loading?
Answer Posted / 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 |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
What is Session and Batches?
Explain the types of lookup transformation?
Explain your project of banking domian.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What the difference is between a database, a data warehouse and a data mart?
What is the scenario which compels informatica server to reject files?
Explain what are the different types of transformation available in informatica.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the types of data warehouses?
Different circumstance which drives informatica server to expel records?
Define update strategy?
What is Data Caches size?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Have you worked with/created Parameter file