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
- 6382 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
Write the prerequisite tasks to achieve the session partition?
What is a surrogate key?
if we have a delimiters at unwanted places in a flat file how can we over come those.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are roles and groups and benefits of using them?
What are the types of caches in lookup?
What are the different ways to implement parallel processing in informatica?
Which files are created during the session rums by informatics server?
What is olap (on-line analytical processing?
What is the different lookup cache(s)?
How we can create indexes after completing the load process?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Describe expression transformation?
