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
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the status code in stored procedure transformation?
Enlist the various types of transformations.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What do you understand by term role-playing dimension?
What is repository manager?
what is song in infrmatica...?
Explain load alternative records / rows into multiple targets - informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How do you take back up of repository?
What is the maplet?
What is the way to execute pl/sql script using informatica mapping?
What is dynamic cache?
What is status code in informatica?