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
- 3749 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 is the Rank index port in Rank transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What does command task mean?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How are indexes created after completing the load process?
Explain the informatica workflow?
what are the Methods For Creating Reusable Transformations?
Did u used latest transformations of 8.6.0? for what?
Which is the t/r that builts only single cache memory?
What is the different lookup cache(s)?
What is the use of transformation?
explain one complex mapping with logic? sales project?
What is the sequence generator transformation in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
update strategy transformation in informatica
