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 any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Mention few power centre client applications with their basic purpose?
Can we create a Integration service without a Repository service and vice versa?
What is the use of an aggregator cache file?
Is it possible to revert a global repository to local one and why?
Explain incremental aggregation in informatica
What is workflow? What are the components of the workflow manager?
How to extract sap data using informatica?
What are some examples of informatica etl programs?
how tokens will generate?
Explain constraint based loading in informatica
How to convert multiple rows to single row (multiple columns) in informatica
What is different between the data warehouse and data mart?
What is sorter transformation?
How can you validate all mappings in the repository simultaneously?