What is the difference between Normal load and Bulk load?
- 5 Answers
- 48503 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
If you enable bulk loading, the PowerCenter Server
bypasses the database log.This improves session performance.
But the disadvantage is that target database cannot perform
rollback as there is no database log.
In normal load the databse log is not bypassed and
therefore the target databse can recover from an incomplete
session.The session performance is not as high as is in the
case of bulk load
| Is This Answer Correct ? | 81 Yes | 4 No |
Answer / harithareddy
normal load performance recovery is possible where as in
bulk mode it is not possible bez, there is no databaselog
to perform rollback
| Is This Answer Correct ? | 44 Yes | 4 No |
Answer / sachin
1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Which is costliest transformation? costly means occupying more memory?
What is rank transformation?
How to load a Dimension ? and how to load a fact table?
What is transformation?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What are the guidelines to be followed while using union transformation?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
Two Default User groups created in the repository are ____ and ______
What is mapping debugger?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What do mean by local and global repository?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
Teradata 
