how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
Answer Posted / gm
You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is rank transformation in informatica
What is parallel processing in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
can we override a native sql query within informatica? Where do we do it?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is status code in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Mention some types of transformation?
Differentiate between a database and data warehouse?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain sessions. Explain how batches are used to combine executions?
Explain your project of banking domian.
What is exclusive and normal mode for repository services?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the different kinds of facts.