What is dimension modeling?
I know of using applysimple, but there are other ways too?
Explain how to export mappings to the production environment?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is data cleaning? How can we do that?
Where can one get more info about Data Warehousing?
How to stop a batch?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is the difference between mapping parameter & mapping variable in data warehousing?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is confirmed dimension?
How can you communicate with web server (apache or iis) from coldfusion?
How to use the tool Ontobulider