>Also i don't think FoxPro is a common tool for data warehousing
>purposes.

It's not a common tool *yet*. However, fox's DML make it a great tool for front-ending and loading a data warehouse. We have quite a few dw's out there utilizing VFP.