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
can you please explain me pre session and post session options?
What is a predefined event?
What is the surrogate key?
What is the meaning of decode in informatica?
what is index?how it can work in informatica
What are the different components of powercenter?
Define Pmrep command?
Can u generate reports in Informatica?
What is a mapplet/worklet in informatica?
What is dynamic cache?
What is the way to execute pl/sql script using informatica mapping?
How will the document be delivered to me?
Explain pushdown optimization and types in informatica
Explain the pipeline partition with real time example?
How to handle decimal places while importing a flatfile into informatica?