Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.
Answer / 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 |
Briefly explain the aggregator transformation?
What is an aggregator transformation? it is active why cant it be passive explain?
"Change cache" in Informatica ?
How to elaborate tracing level?
Is it possible to create multiple domains on a single Informatica server?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
What is event and what are the tasks related to it?
Different sorts of metadata that stores in the storage facility?
If I am having 6 flat files in data. How can you load the data at a time
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
what are the deliverables?in your project?