how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 5362 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 a node in Informatica?
Explain direct and indirect flat file loading (source file type) - informatica
what is the Default Source Option For Update Strategy Transformation?
What is the difference between a repository server and a powerhouse?
Which transformation should we use to normalise the COBOL and relational sources?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
in reporting we add some new objects,how we get the count of the newly added objects to the report
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Write the program through which the records can be updated?
What is lookup transformation?
What does refresh system mean, and what are its distinctive choice?
Is there any way to read the ms excel datas directly into informatica?
Explain the scenario which compels informatica server to reject files?
How to use pmcmd utility command?
What are multi-group transformations?
