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 / abhishek
ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is an aggregator transformation?
How many ways are there to do 'remove duplicate records in informatica'?
Can you generate sequence numbers without using the sequence generator transformation?
r u done any partitions in ur project?
To import the flat file definition into the designer where should the flat file be placed?
What are the advantages of informatica?
What is a sorter transformation?
In informatics server which files are created during the session rums?
Performance tuning in UNIX for informatica mappings?
Why sorter is an active transformation?
What is intricate mapping?
How to create a non-reusable instance of reusable transformations?
what is $$$$?
How can we use mapping variables in informatica? Where do we use them?
Is there any target staging area in informatica not staging area