RESETETL
Definition
Copy
CREATE procedure [BBDW].[RESETETL]
as
set nocount on;
exec BBDW.[CREATE_OR_DROP_ALL_FK] 0;
exec BBDW.[USP_DROPALLCOLUMNSTOREINDEXES];
--sponsorship
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSOR', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSOR_STAGE', 0, 0;
truncate table [BBDW].[DIM_SPONSOR];
truncate table [BBDW].[DIM_SPONSOR_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIP', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIP_STAGE', 0, 0;
truncate table [BBDW].[DIM_SPONSORSHIP];
truncate table [BBDW].[DIM_SPONSORSHIP_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPOPPORTUNITYCHILD', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPOPPORTUNITYCHILD_STAGE', 0, 0;
truncate table [BBDW].[DIM_SPONSORSHIPOPPORTUNITYCHILD];
truncate table [BBDW].[DIM_SPONSORSHIPOPPORTUNITYCHILD_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPOPPORTUNITYPROJECT', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPOPPORTUNITYPROJECT_STAGE', 0, 0;
truncate table [BBDW].[DIM_SPONSORSHIPOPPORTUNITYPROJECT];
truncate table [BBDW].[DIM_SPONSORSHIPOPPORTUNITYPROJECT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPREASON', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPREASON_STAGE', 0, 0;
truncate table [BBDW].[DIM_SPONSORSHIPREASON];
truncate table [BBDW].[DIM_SPONSORSHIPREASON_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPLOCATION', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SPONSORSHIPLOCATION_STAGE', 0, 0;
truncate table [BBDW].[DIM_SPONSORSHIPLOCATION];
truncate table [BBDW].[DIM_SPONSORSHIPLOCATION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPTRANSACTION', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPTRANSACTION_STAGE', 0, 0;
truncate table [BBDW].[FACT_SPONSORSHIPTRANSACTION];
truncate table [BBDW].[FACT_SPONSORSHIPTRANSACTION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPRECURRINGADDITIONALGIFT', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPRECURRINGADDITIONALGIFT_STAGE', 0, 0;
truncate table [BBDW].[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT];
truncate table [BBDW].[FACT_SPONSORSHIPRECURRINGADDITIONALGIFT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE_STAGE', 0, 0;
truncate table [BBDW].[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE];
truncate table [BBDW].[FACT_SPONSORSHIPOPPORTUNITYCHILDATTRIBUTE_STAGE];
--marketing preferences
truncate table [BBDW].[DIM_BUSINESSUNIT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_BUSINESSUNIT', 0, 0;
truncate table [BBDW].[DIM_SOLICITCODE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SOLICITCODE', 0, 0;
truncate table [BBDW].[FACT_CONSTITUENTSOLICITCODE_STAGE];
truncate table [BBDW].[FACT_CONSTITUENTSOLICITCODE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSOLICITCODE_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSOLICITCODE', 0, 0;
truncate table [BBDW].[FACT_SOLICITCODECHANNELOPTOUT_STAGE];
truncate table [BBDW].[FACT_SOLICITCODECHANNELOPTOUT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SOLICITCODECHANNELOPTOUT_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SOLICITCODECHANNELOPTOUT', 0, 0;
truncate table [BBDW].[DIM_IDSETREGISTER];
exec [BBDW].[CREATE_OR_DROP_DIM_IDSETREGISTER_INDICES] 0;
truncate table BBDW.[DIM_SMARTFIELD];
truncate table [BBDW].[FACT_OLAPDATASOURCESMARTFIELD_STAGE];
truncate table BBDW.[FACT_CONSTITUENTSMARTFIELD];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSMARTFIELD', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTSMARTFIELD_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSMARTFIELD_STAGE', 0, 0;
truncate table BBDW.[FACT_REVENUESPLITSMARTFIELD];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUESPLITSMARTFIELD', 0, 0;
truncate table BBDW.[FACT_REVENUESPLITSMARTFIELD_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUESPLITSMARTFIELD_STAGE', 0, 0;
truncate table BBDW.[DIM_ATTRIBUTE];
truncate table [BBDW].[FACT_OLAPDATASOURCEATTRIBUTECATEGORY_STAGE];
truncate table BBDW.[FACT_CONSTITUENTATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTATTRIBUTE_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTREGISTRANTATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_EVENTREGISTRANTATTRIBUTE_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_EVENTATTRIBUTE_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_DESIGNATIONATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DESIGNATIONATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_DESIGNATIONATTRIBUTE_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DESIGNATIONATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MODELINGANDPROPENSITYATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_MODELINGANDPROPENSITYATTRIBUTE_STAGE]
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MODELINGANDPROPENSITYATTRIBUTE_STAG', 0, 0;
truncate table BBDW.[FACT_INTERACTIONATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_INTERACTIONATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_EDUCATIONATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EDUCATIONATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_EDUCATIONATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EDUCATIONATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTADDRESSATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTADDRESSATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTADDRESSATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_PROSPECTPLANATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PROSPECTPLANATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_PROSPECTPLANATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PROSPECTPLANATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_PURPOSELEVELATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PURPOSELEVELATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_PURPOSELEVELATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PURPOSELEVELATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_FUNDINGREQUESTATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDINGREQUESTATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_FUNDINGREQUESTATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDINGREQUESTATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_OPPORTUNITYATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_OPPORTUNITYATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_BENEFITATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_BENEFITATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_BENEFITATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_BENEFITATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONLINEITEMATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_APPEALATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_APPEALATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_APPEALATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_APPEALATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_SPONSORSHIPATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_SPONSORSHIPATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SPONSORSHIPATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[DIM_ETHNICITY];
truncate table BBDW.[FACT_CONSTITUENTETHNICITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTETHNICITY', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTETHNICITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTETHNICITY_STAGE', 0, 0;
truncate table BBDW.[DIM_REVENUERECOGNITIONTYPE];
truncate table BBDW.[FACT_REVENUERECOGNITION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUERECOGNITION_STAGE', 0, 0;
truncate table BBDW.[FACT_REVENUERECOGNITION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUERECOGNITION', 0, 0;
truncate table BBDW.[DIM_FUNDINGREQUESTOUTLINESTEP];
truncate table BBDW.[DIM_FUNDINGREQUEST];
truncate table BBDW.[DIM_PROSPECTPLANREQUESTASSIGNMENT];
truncate table BBDW.[DIM_PLANPARTICIPANT];
truncate table BBDW.[DIM_PLANOUTLINESTEP];
truncate table BBDW.[FACT_REVENUEFUNDRAISER];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUEFUNDRAISER', 0, 0;
truncate table BBDW.[FACT_REVENUEFUNDRAISER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUEFUNDRAISER_STAGE', 0, 0;
--FACT_REVENUEOPPORTUNITY
truncate table BBDW.[FACT_REVENUEOPPORTUNITY_STAGE];
truncate table BBDW.[FACT_REVENUEOPPORTUNITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUEOPPORTUNITY_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUEOPPORTUNITY', 0, 0;
--FACT_EVENTREGISTRATIONOPPORTUNITY
truncate table BBDW.[FACT_EVENTREGISTRATIONOPPORTUNITY_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRATIONOPPORTUNITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRATIONOPPORTUNITY_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRATIONOPPORTUNITY', 0, 0;
--FACT_OPPORTUNITY
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITY', 0, 0;
truncate table BBDW.[FACT_OPPORTUNITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITY_STAGE', 0, 0;
truncate table BBDW.[FACT_OPPORTUNITY_STAGE];
--FACT_INTERACTION
truncate table BBDW.[DIM_INTERACTION];
truncate table BBDW.[FACT_INTERACTION];
exec [BBDW].[CREATE_OR_DROP_FACT_INTERACTION_INDICES] 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTION', 0, 0;
truncate table BBDW.[FACT_INTERACTION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTION_STAGE', 0, 0;
truncate table BBDW.[DIM_RESPONSE];
truncate table BBDW.[FACT_INTERACTIONRESPONSE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONRESPONSE_STAGE', 0, 0;
truncate table BBDW.[FACT_INTERACTIONRESPONSE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONRESPONSE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONPARTICIPANT_STAGE', 0, 0;
truncate table BBDW.[FACT_INTERACTIONPARTICIPANT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONPARTICIPANT', 0, 0;
truncate table BBDW.[FACT_INTERACTIONPARTICIPANT];
--FACT_FUNDRAISERINTERACTIONADDITIONAL
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDRAISERINTERACTIONADDITIONAL', 0, 0;
truncate table BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDRAISERINTERACTIONADDITIONAL_STAGE', 0, 0;
truncate table BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL_STAGE];
truncate table BBDW.[FACT_INTERACTIONSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONSITE', 0, 0;
truncate table BBDW.[FACT_INTERACTIONSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INTERACTIONSITE_STAGE', 0, 0;
truncate table BBDW.[DIM_FUNDRAISERCAMPAIGN];
truncate table BBDW.[DIM_FUNDRAISERSECONDARY];
truncate table BBDW.[DIM_FUNDRAISERTEAM];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_FUNDRAISERTEAM', 0, 0;
truncate table BBDW.[DIM_FUNDRAISERTEAM_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_FUNDRAISERTEAM_STAGE', 0, 0;
truncate table BBDW.[DIM_FUNDRAISERTEAMFLAGS_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_FUNDRAISERTEAMFLAGS_STAGE', 0, 0;
truncate table BBDW.[DIM_FUNDRAISERTEAMURL_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_FUNDRAISERTEAMURL_STAGE', 0, 0;
truncate table BBDW.[DIM_FUNDRAISERTEAMMEMBER];
--FACT_OPPORTUNITYFUNDING
truncate table BBDW.[FACT_OPPORTUNITYFUNDING_STAGE];
truncate table BBDW.[FACT_OPPORTUNITYFUNDING];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYFUNDING_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYFUNDING', 0, 0;
--FACT_OPPORTUNITYCAMPAIGN
truncate table BBDW.[FACT_OPPORTUNITYCAMPAIGN_STAGE];
truncate table BBDW.[FACT_OPPORTUNITYCAMPAIGN];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYCAMPAIGN_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYCAMPAIGN', 0, 0;
--FACT_OPPORTUNITYDESIGNATION
truncate table BBDW.[FACT_OPPORTUNITYDESIGNATION_STAGE];
truncate table BBDW.[FACT_OPPORTUNITYDESIGNATION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYDESIGNATION_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYDESIGNATION', 0, 0;
--FACT_OPPORTUNITYDESIGNATIONCAMPAIGN
truncate table BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN_STAGE];
truncate table BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYDESIGNATIONCAMPAIGN_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_OPPORTUNITYDESIGNATIONCAMPAIGN', 0, 0;
truncate table BBDW.[DIM_FUNDRAISER];
truncate table BBDW.[DIM_PROSPECT];
truncate table BBDW.[DIM_PROSPECTFUNDINGINTEREST];
truncate table BBDW.[DIM_PROSPECTPLAN];
truncate table BBDW.[DIM_SOURCE];
truncate table BBDW.[DIM_CREDITCARDTYPE];
truncate table BBDW.[DIM_OTHERPAYMENTMETHOD];
truncate table BBDW.[DIM_REVENUESCHEDULE];
truncate table BBDW.[FACT_INSTALLMENTWRITEOFF_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INSTALLMENTWRITEOFF_STAGE', 0, 0;
truncate table BBDW.[FACT_INSTALLMENTPAYMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INSTALLMENTPAYMENT_STAGE', 0, 0;
truncate table BBDW.[FACT_INSTALLMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INSTALLMENT_STAGE', 0, 0;
truncate table BBDW.[FACT_INSTALLMENTWRITEOFF];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INSTALLMENTWRITEOFF', 0, 0;
truncate table BBDW.[FACT_INSTALLMENTPAYMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INSTALLMENTPAYMENT', 0, 0;
truncate table BBDW.[FACT_INSTALLMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_INSTALLMENT', 0, 0;
truncate table BBDW.[DIM_INSTALLMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_INSTALLMENT', 0, 0;
truncate table BBDW.[DIM_INSTALLMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_INSTALLMENT_STAGE', 0, 0;
--Recurring gifts
truncate table BBDW.[DIM_RECURRINGGIFTFLAG];
truncate table BBDW.[FACT_RECURRINGGIFTINSTALLMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENT_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENTMISSED_STAGE', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTINSTALLMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENT', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTINSTALLMENTPAYMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENTPAYMENT_STAGE', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTINSTALLMENTPAYMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENTPAYMENT', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTINSTALLMENTWRITEOFF_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENTWRITEOFF_STAGE', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTINSTALLMENTWRITEOFF];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTINSTALLMENTWRITEOFF', 0, 0;
truncate table BBDW.[DIM_RECURRINGGIFTDEVELOPMENT];
truncate table BBDW.[FACT_RECURRINGGIFTDEVELOPMENTHISTORY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTDEVELOPMENTHISTORY_STAGE', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTDEVELOPMENTHISTORY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTDEVELOPMENTHISTORY', 0, 0;
truncate table [BBDW].[FACT_RECURRINGGIFTINSTALLMENTMISSED_STAGE];
truncate table BBDW.[DIM_RECURRINGGIFTSTATUSREASON_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_RECURRINGGIFTSTATUSREASON_STAGE', 0, 0;
truncate table BBDW.[DIM_RECURRINGGIFTSTATUSREASON];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_RECURRINGGIFTSTATUSREASON', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTAMENDMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTAMENDMENT_STAGE', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTAMENDMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTAMENDMENT', 0, 0;
truncate table BBDW.[FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_RECURRINGGIFTAMENDMENTDESIGNATIONS', 0, 0;
truncate table BBDW.[DIM_ADDON];
truncate table BBDW.[DIM_MEMBERSHIPPROGRAM];
truncate table BBDW.[DIM_MEMBERSHIPSTATUS];
truncate table BBDW.[DIM_MEMBERSHIP_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MEMBERSHIP_STAGE', 0, 0;
truncate table BBDW.[DIM_MEMBERSHIP];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MEMBERSHIP', 0, 0;
truncate table BBDW.[DIM_MEMBERFLAG];
truncate table BBDW.[FACT_MEMBER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBER_STAGE', 0, 0;
truncate table BBDW.[FACT_MEMBER];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBER', 0, 0;
truncate table BBDW.[DIM_MEMBERSHIPACTION];
truncate table BBDW.[FACT_MEMBERSHIPTRANSACTION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPTRANSACTION_STAGE', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPTRANSACTION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPTRANSACTION', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPRENEWALRULES_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPRENEWALRULES_STAGE', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPRENEWALRULES];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPRENEWALRULES', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPADDON_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPADDON_STAGE', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPADDON];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPADDON', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPREVENUE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPREVENUE_STAGE', 0, 0;
truncate table BBDW.[FACT_MEMBERSHIPREVENUE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MEMBERSHIPREVENUE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTPRICE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTPRICE_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTPRICE_STAGE];
truncate table BBDW.[FACT_EVENTPRICE];
truncate table BBDW.[DIM_WRITEOFF];
truncate table BBDW.[DIM_EVENTREGISTRATION];
truncate table BBDW.[DIM_EVENTREGISTRATIONCODES];
truncate table BBDW.[DIM_EVENTREGISTRANTROLE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_STORY_STAGE', 0, 0;
truncate table BBDW.[DIM_STORY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTPERSONALURL_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTREGISTRANTPERSONALURL_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EVENTREGISTRANTROLE_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTREGISTRANT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANT_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTREGISTRANT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANT', 0, 0;
--Event tables
truncate table BBDW.[DIM_EVENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EVENT', 0, 0;
truncate table BBDW.[DIM_EVENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EVENT_STAGE', 0, 0;
truncate table BBDW.[DIM_EVENTGOALTYPE];
--Marketing tables
truncate table BBDW.[DIM_MARKETINGSEGMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MARKETINGSEGMENT', 0, 0;
truncate table BBDW.[DIM_MARKETINGSEGMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MARKETINGSEGMENT_STAGE', 0, 0;
truncate table BBDW.[DIM_MARKETINGSOURCECODE];
truncate table BBDW.[DIM_MARKETINGSOURCECODE_STAGE];
truncate table BBDW.[DIM_MARKETINGSOURCECODEPART];
truncate table BBDW.[DIM_MARKETINGSOURCECODEPART_STAGE];
truncate table BBDW.[FACT_MARKETINGCONSTITUENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MARKETINGCONSTITUENT', 0, 0;
truncate table BBDW.[FACT_MARKETINGCONSTITUENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MARKETINGCONSTITUENT_STAGE', 0, 0;
truncate table BBDW.[FACT_MARKETINGREFRESHPROCESS_STAGE];
truncate table BBDW.[DIM_APPEAL];
truncate table BBDW.[DIM_MARKETINGSEGMENTATION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MARKETINGSEGMENTATION', 0, 0;
truncate table BBDW.[DIM_MARKETINGSEGMENTATION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MARKETINGSEGMENTATION_STAGE', 0, 0;
truncate table BBDW.[FACT_MARKETINGSEGMENTATIONDAILYRESPONSE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MARKETINGSEGMENTATIONDAILYRESPONSE', 0, 0;
truncate table BBDW.[FACT_MARKETINGSEGMENTATIONDAILYRESPONSE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MARKETINGSEGMENTATIONDAILYRESPONSE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTADDRESS];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTADDRESS', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTADDRESS_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTADDRESS_STAGE', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTADDRESS];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTADDRESS', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTADDRESSDETAIL];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTADDRESSDETAIL', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTADDRESSFLAG', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTADDRESSFLAG];
truncate table BBDW.[DIM_CONSTITUENTADDRESSTYPE];
truncate table BBDW.[DIM_DONOTMAILREASON];
truncate table BBDW.[DIM_CONSTITUENTDEMOGRAPHIC];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'CONSTITUENTDEMOGRAPHIC', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTINFORMATION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTINFORMATION', 0, 0;
truncate table BBDW.[DIM_CONSTITUENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENT', 0, 0;
truncate table BBDW.[DIM_CONSTITUENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_DIM_CONSTITUENT_STAGE_INDICES] 0;
truncate table BBDW.[DIM_CONSTITUENTINTEREST];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTINTEREST', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTINTEREST_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTINTEREST_STAGE', 0, 0;
--Constituency
truncate table BBDW.[DIM_CONSTITUENCY];
truncate table BBDW.[FACT_CONSTITUENCY];
truncate table BBDW.[CONSTITUENCYCRITERIA];
truncate table BBDW.[FACT_DEFAULTREVENUEFILTER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENCY', 0, 0;
truncate table BBDW.[FACT_CONSTITUENCY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENCY_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTRELATIONSHIP];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTRELATIONSHIP', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTRELATIONSHIP_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTRELATIONSHIP_STAGE', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTRELATIONSHIPSET];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTRELATIONSHIPSET', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTRELATIONSHIPSET_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTRELATIONSHIPSET_STAGE', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTRELATIONSHIPEMPLOYMENT_STAGE', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTRELATIONSHIPTYPE];
truncate table BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG];
truncate table BBDW.[DIM_CONTACTTYPE];
--Site tables
truncate table BBDW.[DIM_SITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SITE', 0, 0;
truncate table BBDW.[DIM_SITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_SITE_STAGE', 0, 0;
truncate table BBDW.[DIM_REVENUECODE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_REVENUECODE', 0, 0;
truncate table BBDW.[DIM_REVENUEFLAG];
truncate table BBDW.[DIM_REVENUECHANNEL];
--Campaign tables
truncate table BBDW.[DIM_CAMPAIGN];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CAMPAIGN', 0, 0;
truncate table BBDW.[DIM_CAMPAIGN_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CAMPAIGN_STAGE', 0, 0;
--Education tables
truncate table BBDW.[DIM_EDUCATION_STAGE];
truncate table BBDW.[DIM_EDUCATION];
truncate table BBDW.[DIM_EDUCATIONADDITIONALINFORMATION_STAGE];
truncate table BBDW.[DIM_EDUCATIONADDITIONALINFORMATION];
truncate table BBDW.[DIM_EDUCATIONALINVOLVEMENT_STAGE];
truncate table BBDW.[DIM_EDUCATIONALINVOLVEMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EDUCATION_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EDUCATION', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EDUCATIONADDITIONALINFORMATION_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EDUCATIONADDITIONALINFORMATION', 0, 0;
exec BBDW.[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EDUCATIONALINVOLVEMENT_STAGE', 0, 0;
exec BBDW.[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EDUCATIONALINVOLVEMENT', 0, 0;
--FACT_CAMPAIGNGOAL
truncate table BBDW.[FACT_CAMPAIGNGOAL_STAGE];
truncate table BBDW.[FACT_CAMPAIGNGOAL];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CAMPAIGNGOAL_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CAMPAIGNGOAL', 0, 0;
truncate table BBDW.[DIM_CAMPAIGNPRIORITY];
truncate table BBDW.[FACT_REVENUECAMPAIGN];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUECAMPAIGN', 0, 0;
truncate table BBDW.[FACT_REVENUECAMPAIGN_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUECAMPAIGN_STAGE', 0, 0;
truncate table BBDW.[DIM_DESIGNATION];
truncate table BBDW.[DIM_PURPOSELEVEL];
truncate table BBDW.[DIM_GLREVENUECATEGORY];
truncate table BBDW.[DIM_DATE];
truncate table BBDW.[DIM_DATE_FISCALPERIOD_STAGE];
truncate table BBDW.[DIM_TIME];
truncate table BBDW.[DIM_TIMEZONE];
truncate table BBDW.[FACT_FINANCIALTRANSACTION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTION_STAGE', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTION', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM_STAGE];
exec [BBDW].[CREATE_OR_DROP_FACT_FINANCIALTRANSACTIONLINEITEM_STAGE_INDICES] 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONLINEITEM', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONLINEITEMSITE_STAGE', 0, 0;
truncate table BBDW.[FACT_FINANCIALTRANSACTIONLINEITEMSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FINANCIALTRANSACTIONLINEITEMSITE', 0, 0;
truncate table BBDW.[FACT_MARKETINGREVENUE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_MARKETINGREVENUE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTAPPEAL];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTAPPEAL', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTAPPEAL_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTAPPEAL_STAGE', 0, 0;
truncate table BBDW.[DIM_WEEK];
truncate table BBDW.[DIM_CONSTITUENTDECEASED_STAGE];
truncate table BBDW.[DIM_PROSPECTPLANSTATUS];
truncate table BBDW.[DIM_CURRENCY];
truncate table BBDW.[DIM_GROUPLEADERS_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_GROUPLEADERS_STAGE', 0, 0;
--Benefits
truncate table BBDW.[DIM_BENEFITTYPE];
truncate table BBDW.[DIM_BENEFIT_STAGE];
truncate table BBDW.[DIM_BENEFIT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_BENEFIT_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_BENEFIT', 0, 0;
--Constituent Email Address Tables
truncate table BBDW.[DIM_CONSTITUENTEMAILADDRESSTYPE];
truncate table BBDW.[DIM_CONSTITUENTEMAILADDRESS];
truncate table BBDW.[FACT_CONSTITUENTEMAILADDRESS_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTEMAILADDRESS_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTEMAILADDRESS];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTEMAILADDRESS', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTEMAILADDRESSFLAG];
--Constituent Phone Tables
truncate table BBDW.[DIM_CONSTITUENTPHONETYPE];
truncate table BBDW.[DIM_CONSTITUENTPHONE];
truncate table BBDW.[DIM_CONSTITUENTPHONEFLAG];
truncate table BBDW.[DIM_DONOTCALLREASON];
truncate table BBDW.[DIM_COUNTRY];
truncate table BBDW.[FACT_CONSTITUENTPHONE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTPHONE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTPHONE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTPHONE', 0, 0;
--CampaignSite tables
truncate table BBDW.[FACT_CAMPAIGNSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CAMPAIGNSITE_STAGE', 0, 0;
truncate table BBDW.[FACT_CAMPAIGNSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CAMPAIGNSITE', 0, 0;
--ConstituentSite tables
truncate table BBDW.[FACT_CONSTITUENTSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSITE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSITE', 0, 0;
--EventSite tables
truncate table BBDW.[FACT_EVENTSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTSITE_STAGE', 0, 0;
truncate table BBDW.[FACT_EVENTSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTSITE', 0, 0;
--ProspectFundingInterestSite tables
truncate table BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PROSPECTFUNDINGINTERESTSITE_STAGE', 0, 0;
truncate table BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PROSPECTFUNDINGINTERESTSITE', 0, 0;
--ProspectPlanSite tables
truncate table BBDW.[FACT_PROSPECTPLANSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PROSPECTPLANSITE', 0, 0;
truncate table BBDW.[FACT_PROSPECTPLANSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PROSPECTPLANSITE', 0, 0;
--TributeSite tables
truncate table BBDW.[FACT_TRIBUTESITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_TRIBUTESITE_STAGE', 0, 0;
truncate table BBDW.[FACT_TRIBUTESITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_TRIBUTESITE', 0, 0;
--Security tables
truncate table BBDW.[DIM_APPUSER];
truncate table BBDW.[DIM_SYSTEMROLE];
truncate table BBDW.[FACT_SYSTEMROLEAPPUSER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SYSTEMROLEAPPUSER_STAGE', 0, 0;
truncate table BBDW.[FACT_SYSTEMROLEAPPUSER];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SYSTEMROLEAPPUSER', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTSECURITYGROUP];
truncate table BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSECURITYGROUPASSIGNMENT_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTSECURITYGROUPASSIGNMENT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTSECURITYGROUPASSIGNMENT', 0, 0;
truncate table BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY_STAGE', 0, 0;
truncate table BBDW.[FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SYSTEMROLEAPPUSERCONSTITUENTSECURITY', 0, 0;
truncate table BBDW.[FACT_SITEPERMISSION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SITEPERMISSION_STAGE', 0, 0;
truncate table BBDW.[FACT_SITEPERMISSION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SITEPERMISSION', 0, 0;
truncate table BBDW.[FACT_QUERYVIEWSECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_QUERYVIEWSECURITY_STAGE', 0, 0;
truncate table BBDW.[FACT_QUERYVIEWSECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_QUERYVIEWSECURITY', 0, 0;
truncate table BBDW.[FACT_DATALISTSECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DATALISTSECURITY_STAGE', 0, 0;
truncate table BBDW.[FACT_DATALISTSECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DATALISTSECURITY', 0, 0;
truncate table BBDW.[FACT_DATALISTSECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DATALISTSECURITY_STAGE', 0, 0;
truncate table BBDW.[FACT_DATALISTSECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DATALISTSECURITY', 0, 0;
truncate table BBDW.[FACT_SYSTEMPRIVILEGESECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SYSTEMPRIVILEGESECURITY_STAGE', 0, 0;
truncate table BBDW.[FACT_SYSTEMPRIVILEGESECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SYSTEMPRIVILEGESECURITY', 0, 0;
truncate table BBDW.[FACT_REPORTSECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REPORTSECURITY', 0, 0;
truncate table BBDW.[FACT_REPORTSECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REPORTSECURITY_STAGE', 0, 0;
truncate table BBDW.[FACT_DATAFORMINSTANCESECURITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DATAFORMINSTANCESECURITY', 0, 0;
truncate table BBDW.[FACT_DATAFORMINSTANCESECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_DATAFORMINSTANCESECURITY_STAGE', 0, 0;
--AccountSystem tables
truncate table BBDW.[DIM_ACCOUNTSYSTEM];
truncate table BBDW.[FACT_ACCOUNTSYSTEMSITE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'ACCOUNTSYSTEMSITE_STAGE', 0, 0;
truncate table BBDW.[FACT_ACCOUNTSYSTEMSITE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_ACCOUNTSYSTEMSITE', 0, 0;
-- tribute table
truncate table BBDW.[DIM_TRIBUTE_STAGE];
truncate table BBDW.[DIM_TRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_TRIBUTE_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_TRIBUTE', 0, 0;
-- revenuetribute table
truncate table BBDW.[FACT_REVENUETRIBUTE_STAGE];
truncate table BBDW.[FACT_REVENUETRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUETRIBUTE_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUETRIBUTE', 0, 0;
-- Benefit total
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTBENEFITTOTAL_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTBENEFITTOTAL', 0, 0;
truncate table BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL];
-- Registrant total
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REGISTRATIONTOTAL_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTTOTAL', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REGISTRATIONTOTALRAISED', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REGISTRATIONTOTALGROUP_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REGISTRATIONTOTALCOMMUNICATIONS_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REGISTRATIONTOTALPARTICIPANTS_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REGISTRATIONTOTALSOCIALMEDIA_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTTOTALDONORRETENTION_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTTOTALPENDING_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTTOTALLASTLOGIN_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTFEES_STAGE', 0, 0;
truncate table BBDW.[FACT_REGISTRATIONTOTAL_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRANTTOTAL];
truncate table BBDW.[FACT_REGISTRATIONTOTALRAISED_STAGE];
truncate table BBDW.[FACT_REGISTRATIONTOTALGROUP_STAGE];
truncate table BBDW.[FACT_REGISTRATIONTOTALCOMMUNICATIONS_STAGE];
truncate table BBDW.[FACT_REGISTRATIONTOTALPARTICIPANTS_STAGE];
truncate table BBDW.[FACT_REGISTRATIONTOTALSOCIALMEDIA_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRANTTOTALPENDING_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRANTTOTALDONORRETENTION_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRANTTOTALLASTLOGIN_STAGE];
truncate table BBDW.[FACT_EVENTREGISTRANTFEES_STAGE];
-- Registrant Benefits
truncate table BBDW.[FACT_EVENTREGISTRANTBENEFIT];
truncate table BBDW.[FACT_EVENTREGISTRANTBENEFIT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTBENEFIT_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EVENTREGISTRANTBENEFIT', 0, 0;
-- Group Total
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDRAISERTEAMTOTAL_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDRAISERTEAMTOTALEXTENSION_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_FUNDRAISERTEAMTOTAL', 0, 0;
truncate table [BBDW].[FACT_FUNDRAISERTEAMTOTAL_STAGE]
truncate table [BBDW].[FACT_FUNDRAISERTEAMTOTALEXTENSION_STAGE]
truncate table [BBDW].[FACT_FUNDRAISERTEAMTOTAL]
truncate table [BBDW].[DIM_ADJUSTMENTREASON]
truncate table [dbo].[REPORTSERVERCREDENTIALS];
truncate table [BBDW].[DIM_CONDITIONSETTING];
--FACT_SMARTQUERYSECURITY
truncate table BBDW.[FACT_SMARTQUERYSECURITY];
truncate table BBDW.[FACT_SMARTQUERYSECURITY_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SMARTQUERYSECURITY_STAGE', 0, 0;
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_SMARTQUERYSECURITY', 0, 0;
--Groups
truncate table BBDW.[DIM_CONSTITUENTGROUP_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTGROUP_STAGE', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTGROUP];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_CONSTITUENTGROUP', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTGROUPMEMBER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTGROUPMEMBER_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTGROUPMEMBER];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTGROUPMEMBER', 0, 0;
truncate table BBDW.[DIM_CONSTITUENTGROUPMEMBERROLE];
truncate table BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTGROUPMEMBERROLE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTGROUPMEMBERROLE', 0, 0;
--Mail Preferences
truncate table BBDW.[DIM_PROCESS_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_PROCESS_STAGE', 0, 0;
truncate table BBDW.[DIM_PROCESS];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_PROCESS', 0, 0;
truncate table BBDW.[DIM_MAILPREFERENCE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_MAILPREFERENCE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTMAILPREFERENCE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTMAILPREFERENCE_STAGE', 0, 0;
truncate table BBDW.[FACT_CONSTITUENTMAILPREFERENCE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_CONSTITUENTMAILPREFERENCE', 0, 0;
--Revenue Letter
truncate table BBDW.[DIM_LETTER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_LETTER_STAGE', 0, 0;
truncate table BBDW.[DIM_LETTER];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_LETTER', 0, 0;
truncate table BBDW.[FACT_REVENUELETTER_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUELETTER_STAGE', 0, 0;
truncate table BBDW.[FACT_REVENUELETTER];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_REVENUELETTER', 0, 0;
--Giving List Details
truncate table [BBDW].[RPT_GIVINGLISTDETAIL_RECOGNITION];
truncate table [BBDW].[RPT_GIVINGLISTDETAIL_CAMPAIGNS];
truncate table [BBDW].[RPT_GIVINGLISTDETAIL_SOLICITORS];
truncate table [BBDW].[RPT_GIVINGLISTDETAIL_SITES];
truncate table [BBDW].[RPT_GIVINGLISTDETAIL];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'RPT_GIVINGLISTDETAIL', 0, 0;
--Recognition Giving List Details
truncate table [BBDW].[RPT_RECOGNITIONGIVINGLISTDETAIL];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'RPT_RECOGNITIONGIVINGLISTDETAIL', 0, 0;
--Planned Giving
truncate table BBDW.[DIM_PLANNEDGIFT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_PLANNEDGIFT_STAGE', 0, 0;
truncate table BBDW.[DIM_PLANNEDGIFT];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_PLANNEDGIFT', 0, 0;
truncate table BBDW.[FACT_PLANNEDGIFTADDITION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PLANNEDGIFTADDITION_STAGE', 0, 0;
truncate table BBDW.[FACT_PLANNEDGIFTADDITION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PLANNEDGIFTADDITION', 0, 0;
truncate table BBDW.[FACT_PLANNEDGIFTATTRIBUTE_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PLANNEDGIFTATTRIBUTE_STAGE', 0, 0;
truncate table BBDW.[FACT_PLANNEDGIFTATTRIBUTE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PLANNEDGIFTATTRIBUTE', 0, 0;
truncate table BBDW.[FACT_PLANNEDGIFTDESIGNATION_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PLANNEDGIFTDESIGNATION_STAGE', 0, 0;
truncate table BBDW.[FACT_PLANNEDGIFTDESIGNATION];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_PLANNEDGIFTDESIGNATION', 0, 0;
--Luminate Online Email
truncate table BBDW.[FACT_EMAILACTIVITY_STAGE];
truncate table BBDW.[FACT_EMAILACTIVITY];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'FACT_EMAILACTIVITY', 0, 0;
truncate table BBDW.[DIM_EMAILCAMPAIGN_STAGE];
truncate table BBDW.[DIM_EMAILCAMPAIGN];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EMAILCAMPAIGN', 0, 0;
truncate table BBDW.[DIM_EMAILMESSAGE_STAGE];
truncate table BBDW.[DIM_EMAILMESSAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_EMAILMESSAGE', 0, 0;
truncate table BBDW.[DIM_ONLINECONSTITUENT_STAGE];
exec [BBDW].[CREATE_OR_DROP_INDICES] 'BBDW', 'DIM_ONLINECONSTITUENT_STAGE', 0, 0;
truncate table BBDW.[ETLCONTROL];
if object_id('BBDW.RESETETL_EXT','P') is not null
exec BBDW.[RESETETL_EXT];