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
- 6291 Views
- Sonata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
The order of loading the schema is as below:
1)Dimension Table
2)fact table
| Is This Answer Correct ? | 5 Yes | 0 No |
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is target designer and target load order?
What is exclusive and normal mode for repository services?
what is the size of u r source(like file or table)?
Where can we find the throughput option in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How to do unit testing in informatica?
Explain the informatica workflow?
How to open an older version of an object in the workspace?
how do u use sequence created in oracle in informatica? Explain with an simple example
with out using update strategy transnsformation how to update the data in mapping level
What are the new features of the server manager in the informatica 5.0?
Teradata 
