Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.
- 1 Answers
- 4321 Views
- I also Faced
- E-Mail Answers
Answer Posted / rao
Firstly we have to load the dimension tables.from dimension
tables take the primary key reference and load the Fact table.
That mean if you have dimensions like product,branch,customer,
we load product id,branch id,customer id(only surrogate keys)
to fact table .later measure will be loaded.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are pre and post-session shell commands?
What is rank transformation in informatica
Explain what transformation and how many are there in informatica?
Separate from an archive server and a powerhouse?
Explain the difference between mapping parameter and mapping variable?
waht type of interface is used for testing the data in informatica
How to use procedural logic inside infromatica?
Describe expression transformation?
have u done any performance tuning? how u ll do?
What are the differences between oltp and olap?
Whats there in global repository
What is data transformation manager process?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Briefly explain the aggregator transformation?
