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
- 4297 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 size of u r database?
Explain incremental aggregation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the new features of informatica 9.x in developer level?
What are the tasks that source qualifier perform?
What is Session and Batches?
What are the advantages of using informatica as an etl tool over teradata?
can anyone suggest best free Talend data integration training online
What are the limitations of joiner transformation?
Is stop and abort are same in informatica?
How do you convert single row from source into three rows into target?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the different types of olap? Give an example?
Explain transaction control transformation in informatica
What is dynamic cache?
