Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bulk Load and Normal Load
- 3 Answers
- 13315 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
Bulk Load: It is preferable when the volume of data is huge
from source system. if we select bulk loading, integration
service doesn't create Database log, that's the reason we
cant perform session recovery.But bulk loading can improve
the performance of session.
Normal Load:If we select normal loading,integration service
create Database log before loading the data into Target.
This database log having the information of last ROWID of
the record for recent load data.it can support session
recovery.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
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
What are the new features of informatica 9.x developer?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the format of informatica objects in a repository?
What is the fact table?
How can informatica be used for an organization?
draw informatica architecture 8.6 ?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the cumulative sum and moving sum?
What is event and what are the tasks related to it?
Explain about cumulative Sum or moving sum?
Explain the tuning lookup transformation - informatica
list out all the transformations which use cache?
