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
- 25050 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajupatel
Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
waht type of interface is used for testing the data in informatica
Quickly characterize reusable change?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is sequence generator transformation in informatica?
What is domain in terms of informatica?
What is different between the data warehouse and data mart?
What is fact table? Explain the different kinds of facts.
What is main use of mapplet?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to load the data from a flat file into the target where the source flat file name changes daily?
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?
What are the new features of Power Center 5.0?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
