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 / ranjan
it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What are the settings that you use to configure the joiner transformation?
draw informatica architecture 8.6 ?
What is session task and command task?
what is the hint? how to use it to reduce the query processing in program?
Which development components of informatica have the highest usage?
Explain scd type 3 through mapping.
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.
update strategy transformation in informatica
what is the size of u r source(like file or table)?
wat are deployement groups in informatica, how it will be used for developers
Explain how to import oracle sequence into informatica?
Explain the tuning lookup transformation - informatica
Explain incremental aggregation in informatica
Explain what transformation and how many are there in informatica?
What are the different ways to implement parallel processing in informatica?