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
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
list out all the transformations which use cache?
Where do we use mapping variables in informatica?
Differentiate between a repository server and a powerhouse?
What are ETL Tools?
Write the program through which the records can be updated?
What is a code page?
how tokens will generate?
What is the benefit of session partitioning?
Plz can any one say me how to get the informatica certification materials and dumps
How to use pmcmd utility command?
What does refresh system mean, and what are its distinctive choice?
Define mapping and session?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
4 yrs etl devloper roles and responsibilities?any body give solutions