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 |
performance tuning of Informatica
which one is better performance wise joiner or look up
why normalizer transformation can not used in mapplet? plzzzz answer
Can we call a stored procedure from a unix script which is run using command task
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is resilience time?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
What is the status code?
tell me about your project functionality
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to recover the standalone session?