Question regarding Datawarehouse testing
Hi I would appreciate if anyone of you can give me suggestion on this scenerio.
"Given a scenario where a single file is parsed into more than say 1000 columns in different tables say more than 10.If the person testing this would need to be able to code some scripts quickly to run a comparison of values between source file and relational staging table columns.Can it be done say by using macros in Excel??"
Please give your suggestions and possible solution.I appreciate if you can send a sample script(if any)
Thanks in Advance
Re: Question regarding Datawarehouse testing
There are many many solutions.
Here are a couple possible solutions:
1) Depending on your query tool, you could write a looping construct to query both the spreadsheet using one connection, and the staging database using another connection. Compare each value upon retrieval.
2) You could replicate the model in above using MS-Access and some VBA.
3) You could use VBScript or other language to accomplish above.
As you can see, there are many options. You could use macros in Excel if you are willing to settle for a turtle's pace.