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
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is rank transform?
Tell me about Propagate functions in informatica
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to join three sources using joiner?
Explain the scenario which compels informatica server to reject files?
What is an expression transformation in informatica?
Is stop and abort are same in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many ways are there to do 'remove duplicate records in informatica'?
what is the difference between informatica6.1 and infomatica7.1
What is the benefit of session partitioning?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the advantages of informatica?