What is data merging, data cleansing and sampling?
datacleaning means duplicate data removing,meging means
combing data from sql,oracle and other ets and dumped into
dataware house
| Is This Answer Correct ? | 2 Yes | 0 No |
How can we import and export using BCP utility?
What is BCP?
Explain the difference between data ware house & data mart?
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 Drill by? drill through?
difference between For each and for all
Why null values are mapped as 0 in fact tables?
What are the different ways to represent the loading of dimension tables?
What is meta data and system catalog?
Explain when do we analyze the tables? How do we do it?
What are the different types of schemas used in data warehousing?
For faster process, what we will do with the universe?