Explain the difference between keylokup and joiner?
No Answer is Posted For this Question
Be the First to Post Answer
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,
What is meant by metadata in context of a data warehouse?
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?
Explain what are the various reporting tools in the market?
What are the other names given to data warehousing?
Can we take backup when the database is opened?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
Explain the hierarchies level data warehousing.
how much memory space occupied real time project (roughly)?
What is difference between query studio and report studio?
What Oracle features can be used to optimize my Warehouse system?
Start a batches with in a batch?