Hi, This is Ranadheer. How to load fact tables using
dimeension tables. Please anyone give me a answer with
example. Thanks in Advance.



Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a an..

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

Post New Answer

More Informatica Interview Questions

performance tuning of Informatica

1 Answers  


which one is better performance wise joiner or look up

0 Answers   Informatica,


why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,


Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,






Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


What is resilience time?

0 Answers  


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.

2 Answers   TCS,


What is the status code?

1 Answers  


tell me about your project functionality

0 Answers  


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,


How to recover the standalone session?

2 Answers  


Categories