Folks,
I have two tables A and B. These two tables are created in such a way that Table A has a parent key relationship on few attributes in Table B and Table B has a Parent Key relationship on few attributes in Table A.
I need to do destructive loading on these two tables every night.I now I can drop the integrity constraints before and re-build them again after.But is there any best way of doing the etl job for these two tables with out dropping constraints(optional).Please throw your suggestions.Any help would be greatly appreciated.
Thanks
Integrity Constant
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Tue Apr 11, 2006 2:35 pm
Re: Integrity Constant
Not Clear...how would you be able to drop your integrity constraints, load the data and then rebuild them.. ? if i understood correctly..vardhan354 wrote:Folks,
I have two tables A and B. These two tables are created in such a way that Table A has a parent key relationship on few attributes in Table B and Table B has a Parent Key relationship on few attributes in Table A.
I need to do destructive loading on these two tables every night.I now I can drop the integrity constraints before and re-build them again after.But is there any best way of doing the etl job for these two tables with out dropping constraints(optional).Please throw your suggestions.Any help would be greatly appreciated.
Thanks
the best way to maintain integrity would be to perform lookups and then load the target based on the lookup results..
Deepak
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sure, just go ahead and load.
But it will be faster without the constraints. If you can promise the DBA that your data will not violate any constraints, then it ought to be OK to drop them and later re-impose them. After all, an empty table is not needful of constraints.
But it will be faster without the constraints. If you can promise the DBA that your data will not violate any constraints, then it ought to be OK to drop them and later re-impose them. After all, an empty table is not needful of constraints.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.