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
- 4399 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
What are the limitations of joiner transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is dimensional table? Explain the different dimensions.
What is intricate mapping?
What are the transformations that are not supported in mapplet?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is lookup change?
Explain the features of connected and unconnected lookup.
What is domain and gateway node?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What will be the approach?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Write the unconnected lookup syntax and how to return more than one column.
what is the complex transformation you used in informatica
How to join three sources using joiner? Explain though mapping flow.
