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 |
Explain the difference between oltp and olap?
Why fact table is in a normal form?
What is the function of surrogate key in data warehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What is the definition of cube in datawarehousing?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what is data validation strategies for data mart validation after loading process?
What is the differences between star and snowflake schemas?
Explain what is the difference between stop and abort?
Why denormalization is promoted in universe designing?
What is META DATA information in Data warehousing projects?