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
Explain your project of banking domian.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
r u done any partitions in ur project?
What do think which one is the better joiner or look up?
What is exclusive and normal mode for repository services?
What are the different versions of informatica?
What is Session and Batches?
How many ways a relational source definition can be updated and what are they?
How to elaborate powercenter integration service?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the advantages of using informatica as an etl tool over teradata?
Describe data concatenation?
What you know about transaction control transformation?
Define Pmrep command?
Explain the use of aggregator cache file?