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 |
Explain dimensional modelling?
What is a Data Cube?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain datawarehousing?
Which columns go to the fact table and which columns go the dimension table?
What is the difference between data warehouse and operational systems?
How do we design a universe?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain the different types of data warehousing?
How can you define a transformation? What are different types of transformations in Informatica?
Explain the difference between data ware house & data mart?
How to calculate fact table granularity?