major difference between normal loading and bulk loading?
Answer Posted / james
The major difference is while going with normal load,we can
have session recovery whereas in Bulk loading we can't.
Some of the other differences are as follows:
Normal Bulk
1.Enters session log before 1.Doesn't enter the session
loading into target there by log and loads directly in
increasing the loading time. target there by decreasing
the loading time.
2.Less performance. 2.High performance.
3.Indexing possible. 3.No concept of indexing.
4For small amount of data. 4.For huge amount of data.
Please let me know if you have any further differences.
Thanks.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
Can you use flat files in Mapplets.
Why do you use Mapping Parameter and mapping variable?
What are the issues you have faced in your project? How did you overcome those issues?
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
Explian the Process of deployment groups in informatica
How do you load only null records into target? Explain through mapping flow.
where to store informatica rejected data? How to extract the informatica rejected data?
What is a filter transformation and why it is an active one?
Explain the informatica workflow?
What is the sequence generator transformation in informatica?
Define enterprise data warehousing?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is informatica? Why do we need it?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?