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
What are data validation strategies for data mart validation after loading process?
Explain the structure of cold fusion?
What is real-time datawarehousing?
What is a relationship?
Explain a mapping, session, worklet, workflow, mapplet?
Explain what are the advantages of query studio compared to report studio?
Explain how to export mappings to the production environment?
What is an er diagram?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the differences between datamart vs. Reporting cube?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What a static and local variable?
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?
What is meta data and system catalog?
Explain why are oltp database designs not generally a good idea for a data warehouse?