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 |
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 347 what is hybrid slowly changing dimension?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Explain datawarehousing?
What are parallel querys and query hints?
List any five applications of data warehouse.
What is drilling across?
Explain what is full load & incremental or refresh load?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
what is parallelism?
What is a view as it relates to system modeling?
What is bi?
Where we use surrogate key explain with example?