how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
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
Can anyone tell me the new features in Informatica 9 Version?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between source qualifier transformations source filter to filter transformation?
In development project what is the process to follow for an etl developer from day1
Explain what are the different versions of informatica?
What is meant by a domain?
What is target designer and target load order?
What is dynamic cache?
How can you define user defied event?
What are the components of the workflow manager?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
tell me about your project functionality
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?