Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ajay kumar
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 |
Post New Answer View All Answers
Explain the difference between oltp and olap?
What is metadata in context of a datawarehouse and how it is important?
What is the difference between aggregate table and materialized view?
What is called dimensional modelling?
What are the different types of join operations?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is a data profile?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Explain bus schema?
What are the types of SCD?
What is the difference between ods and oltp?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is surrogate key? Where we use it? Explain with examples.
What is the difference between junk dimension and degenerated dimension?
Why is business intelligence (bi) important in data warehousing?
