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 / dhana
Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
update strategy transformation in informatica
can we override a native sql query within informatica? How do we do it?
How to do the error handling of if ur source is flatfiles?
What is a joiner transformation and why it is an active one?
What is a repository manager?
Did u used latest transformations of 8.6.0? for what?
Enlist the differences between database and data warehouse.
what is $$$$?
What is parallel processing in informatica?
Is there any way to read the ms excel datas directly into informatica?
Write the advantages of partitioning a session?
Enlist few areas or real-time situations where informatica is required.