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
Tell me about Propagate functions in informatica
What is a rank transform?
without table how to come first record only in oracle?
What is blocking transformation?
What is the reusable transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to load data in informatica ?
What is enterprise data warehousing?
Separate from an archive server and a powerhouse?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain informatica architecture - version 8 / 9
what is diff b/t sorter t/r and agg have the option sorter property...
What is Data Caches size?
How can we create index after completion of load process?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com