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 |
I have 1200 records how can u send it in aggregator with good performance issues?
what is system requirement(SR) & business requirement(BR)?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Explain constraint based loading in informatica
To import the flat file definition into the designer where should the flat file be placed?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
What is a passive transformation?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
how many types transformations supported by sortedinput?