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 / rajupatel
Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Write the prerequisite tasks to achieve the session partition?
Scheduling properties,whats the default (sequential)
Explian the Process of deployment groups in informatica
What are the guidelines to be followed while using union transformation?
How union transformation is used?
What does update strategy mean, and what are the different option of it?
What is rank transformation?
Repository user profiles
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain lookup transformation source types in informatica
On which transformations you created partitions in your project?
what are 3 tech challenges/ common issues you face?
What the difference is between a database, a data warehouse and a data mart?
Is it possible to create multiple domains on a single Informatica server?
What is enterprise data warehousing?