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
- 25492 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
What is the difference between informatics 7x and 8x and what is latest version?
permutations of mapplet
What are the main issues while working with flat files as source and as targets ?
What is the need of an ETL tool?
How to elaborate tracing level?
How to handle decimal places while importing a flatfile into informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the benefit of session partitioning?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to load a Dimension ? and how to load a fact table?
Why sorter is an active transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How you prepared reports for OLAP?
