What is the difference between Bulk Load and Normal Load
Answer Posted / prasad
Normal Load: Normal load option in session properties will
load records one-by-one and generate log for the informztion.
Bulk load: It will load all records at a time and did not
generate session log for records.. when you enable bulk load
the IS invokes sql loaders and bypass database log.
in normal we can able to recovery session
but bulk load cannot recover the sesion
..correct me if i am wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is event and what are the tasks related to it?
In warehouses how many schemas are there?
Explain the different dimensions.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
my source is junk data how will u remove that junk data by using unix please any one replay me
How many ways are there to do 'remove duplicate records in informatica'?
Where are the source flat files kept before running the session?
r u done any partitions in ur project?
How do you take back up of repository?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the difference between writing a joiner query in ANSI style and THETA style?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the components of workflow manager?
Different sorts of metadata that stores in the storage facility?
Explian the Process of deployment groups in informatica