Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Normal load and Bulk load?
- 5 Answers
- 50982 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 |
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
What is the query to find nth highest salary? What is the use of cursors?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
What is informatica worklet?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Does Facttable Normalized or Denormalized?
Can you copy the session to a different folder or repository?
How to delete first 3 rows & last 3 rows in target table in informatica
Can i create a lookup table without cache.
How are the sources and targets definitions imported in informatica designer?
what is session override?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
Teradata 
