What is BCP?
Answer / guest
Bulk Copy Pogram
Two plugins are automatically installed with Data stage.
1. BCPLoad plugin-used to bulk load data in single table in
MS SQL server.
2. OraBulk Plugin
| Is This Answer Correct ? | 0 Yes | 1 No |
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What is the difference between narmal load and bulk load?
What is surrogate key? Where we use it explain with example?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain what are non-additive facts in detail?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain the main differences between star and snowflake schema?
What are necessary tasks to install reportnet software?
Why we use repository connectivity?
what are the types of dimension tables
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?