Interested to Buy Any Domain ? << Click Here >> for more details...
major difference between normal loading and bulk loading?
- 6 Answers
- 12397 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
How do you load unique records into one target table and duplicate records into a different target table?
State the differences between sql override and lookup override?
What is the use of source qualifier?
Explain the types of lookup transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is the sequence generator transformation in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the restrictions of union transformation?
How to do the error handling of if ur source is flatfiles?
What are the advantages of using informatica as an etl tool over teradata?
Enlist the differences between database and data warehouse.
Explain sql transformation in script mode examples in informatica
What is pmcmd command?
What is flashback table ? Advance thanks
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
