Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 25496 Views
- TCS, I also Faced
- E-Mail Answers
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 the Process to creating lookup transformation in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is incremental aggregation?
Separate from a database, an information bazaar, and an information stockroom?
Why union transformation is an active transformation?
What are the new features of informatica 9.x in developer level?
What do you mean by filter transformation?
How many ways a relational source definition can be updated and what are they?
What are the issues you have faced in your project? How did you overcome those issues?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is option by which we can run all the sessions in a batch simultaneously?
What is the need of etl tools?
Explain constraint based loading in informatica
What could be the possible resons of locks by user?
