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 8015Post New Extech Data Warehouse General Interview Questions
-
Extech Data Warehouse General Interview Questions (1)
How to find schema of a table in db2?
What are the main causes of the loss of the biological diversity nowadays?
What is the difference between a mechanical engineer & a Marine engneer?
an array of size N in which every number is between 1 and N, determine if there are any duplicates in it. You are allowed to destroy the array if you like. [ I ended up giving about 4 or 5 different solutions for this, each supposedly better than the others ].
What is isolation level? How to set it?
How we can call a model from view in cakephp?
can we make bricks using m10 grade cement concrete and what would be the ratio of raw materials used and price per brick ?
What is @override annotation in java?
Compare linux credit based algorithm with other scheduling algorithms?
Is stop and abort are same in informatica?
What is a trigger? How do you verify if a trigger is fired or not?
Is it possible to create parallel approval process (ability for multiple user to approve or reject a record)? : salesforce workflows and approval process
What is viewholder-pattern?
Define What is unit weight of normal concrete?
What are the types of jit?
