how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 5402 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 the difference between informatica6.1 and infomatica7.1
What do you mean by channel change?
what are the Methods For Creating Reusable Transformations?
can you please explain me pre session and post session options?
Define enterprise data warehousing?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
difference between repository database and repository service?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to go to the older version for a mapping?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Is there any target staging area in informatica not staging area
What is pmcmd command?
Why filter transformation is an active one?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
