Interested to Buy Any Domain ? << Click Here >> for more details...
major difference between normal loading and bulk loading?
- 6 Answers
- 12572 Views
- I also Faced
- E-Mail Answers
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 are session parameters ? How do you set them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What does refresh system mean, and what are its distinctive choice?
What is the difference between Active and Passive transformation?
What are the differences between a connected lookup and unconnected lookup?
Can we override a native sql query within informatica?
What is fact table? Explain the different kinds of facts.
Briefly explain the aggregator transformation?
where to store informatica rejected data?
Explain in detail scd type 2 through mapping.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Is it possible to revert a global repository to local one and why?
What does role playing dimension mean?
Reusable transformation and shortcut differences
