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 |
how can run the wf through pmcmd commend? write script?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
What is intricate mapping?
What are the databases that informatica can connect to windows?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
4 yrs etl devloper roles and responsibilities?any body give solutions
How to elaborate powercenter integration service?
Explain about cumulative Sum or moving sum?
how to delete duplicate records by using filter transfermation?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.