What is the difference between Normal load and Bulk load?
Answer Posted / 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 |
Post New Answer View All Answers
What is the fact table?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Define pmcmd command?
Which transformation is needed while using the Cobol sources as source definitions?
Explian the Process of deployment groups in informatica
What is the difference between informatics 7x and 8x and what is latest version?
Target increases every day even though no new record was inserted
What are the different lookup cache(s)?
How to join three sources using joiner? Explain though mapping flow.
How to partition the Session?
What does “tail –f” command do and what is its use as an Informatica admin.
What is domain in terms of informatica?
How you can differentiate between connected lookup and unconnected lookup?
What is transformation?
What are the types of schemas we have in data warehouse.