Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
Answer Posted / ranjan
it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
r u done any partitions in ur project?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the difference between writing a joiner query in ANSI style and THETA style?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What do you mean by worklet?
How many number of sessions can one group in batches?
can u give example for factless fact table
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Differentiate between Load Manager and DTM?
What is lookup change?
permutations of mapplet
How would you join a node to the already existing domain?
How can we use batches?
Suppose we do not group by on any ports of the aggregator what will be the output?
can we override a native sql query within informatica? How do we do it?