| Refferential Integrities [message #542483] |
Tue, 07 February 2012 07:59  |
 |
newbie80
Messages: 1
Registered: February 2012
Location: Princeton
|
Junior Member |
|
|
Hi -
Currently we are building a big datamart. For our FACT table we have about 15 Foreign Keys joining with all DIM tables. Couple of DIM tables are pretty big. So enforcing the RI's while loading means we are compromising our loading time. Takes hours to load even small set of data. We have 0 SID in all our DIM tables.
Now the team is divided between having no RI and keeping the RIs. My question is "What's the best practice when it comes to having almost a billion record DIM tables. Is it still recommended to keep RIs. Or no need for it. Create a validation report after the fact load to find any data inconsistency?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
