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
- 6244 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 |
What is the difference between sequential batch and concurrent batch and which is recommended and why?
How to load duplicate records in to a target table which has a primary key?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Different types of Power center errors?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
how to call lookup qualifer in unconnected look;up
What are the types of groups in Router transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to delete duplicate record in Informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is fact and what types of fact tables is there
what are cost based and rule based approaches and what is the difference?
Teradata 
