Interested to Buy Any Domain ? << Click Here >> for more details...
how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 6493 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / sree
dimension tables are loaded first and fact tables.As all primary keys of the dimension table is linked with the foreign keys of fact table for proper lookup we need to load dimension tables first.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is meant by lookup transformation?
What is the advantage of informatica?
How to handle decimal places while importing a flatfile into informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain what transformation and how many are there in informatica?
how we can load rejected record's at run time?(not through bad files)
How can we handle two sessions in informatica?
Write the different tools in the workflow manager?
How can informatica be used for an organization?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a grid in Informatica?
How might one distinguish in the case of mapping is right or not without associating session?
When do you use sql override in a lookup transformation?
Implementation methodology
Where are the source flat files kept before running the session?
