Interested to Buy Any Domain ? << Click Here >> for more details...
What does "bulk loading of a table" mean? Can you describe
advantages or disadvantages of using these features?
- 2 Answers
- 12994 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / harendrakumarlinux
Loading bulk data into tables is one of the most common
tasks in data warehouse applications. As the data volume
increases, so does the complexity of the loading process.
While loading bulk data, you should not only consider how
much time it takes to load the data, but also consider the
concurrency and data availability requirements, and the
maintenance operations, such as creating or rebuilding
indexes. Bulk data loading can take a significant amount of
time. Therefore, you should consider the options that enable
fast loading of data. However, loading fast is not enough.
Loading bulk data can, at times, cause escalation of locks
and impact other concurrent transactions on the table. For
applications requiring concurrent data access during load,
you should consider options that provide the desired
concurrency. Availability of existing data while the new
data is being loaded is also an important consideration to
help you choose the right option. Creating and rebuilding
indexes is an essential part of the data loading process,
but can be time-consuming for large tables. However, there
are ways to create indexes on the freshly loaded data
without impacting the data in the rest of the table.SQL
Server 2005 provides partitioned tables, and while loading
data into a partitioned table, you can have several options.
Each option provides its own distinct advantages, but the
option you choose depends upon the requirements of your
application, such as performance, concurrency, temporary
storage, and so on
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Explain a path in unix.
How the Kernel handles the copy on write bit of a page, when the bit is set?
What is grep|sort give example?
What is a filter in unix?
Differentiate between paging and swapping?
Describe the responsibilities of shell in brief.
What is the difference between nfs 3 and nfs 4?
What is unix in simple terms?
What do you mean by the protection fault?
Is it possible to see information about a process while it is being executed?
Name the key features of the bourne shell.
In unix, what is echo used for?
What is alias mechanism? Explain.
Define the term directory?
What is Process id in unix?
