Thank you so much for the reply. Apologies for still being unclear about the question raised by me , its a new job I started just few weeks back , and it looks like we are looking for automated unit tests to be carried out and its a continuos integfration with no smoke tests,Can you please guide me of what needs to be done to build some smoke tests for the datawarehouse in continuos integration ...are there any tools or any manual approach to do this.