How to prepare dimensional model for internet sales?What are the business requirements for internet marketing/sales/

How to Build Time Dimenion in Datawarehousing?

Where exactly do you use XML, XSLT, X-PATH, X-QUERY & BPEL

How you differentiate between SOA & Web Services?

How could you tell whether a system was regular TBX, micro BTX, or pico BTX?

What is Cardinality? What are the different types of Cardinality? How will you define Cardinality to outer join, left join, right join, inner join, fact to fact and dimension to dimesion?

What is Real-Time Data Warehousing?

How to create content store in the network and how to connect the remote database?

How to use version control. What are the options which is use in the version control

How data security is provided in Data Warehouse?

How to compare values in data table?

What is the life cycle of Data Warehousing in Real-time?

What is meant by mimic diagram? Where it is used?

What is a use of ROLLUP and CUBE in ORACLE? How do they help Data Warehousing applications?

How to remove a particular attribute from table using the information gain concept?

What is a custom dimension?

How can we remove duplicates from fact table?

How to get rejected data from the join stage without using any stages after join?

What are the prioritized Rules in Transform function?

What is the Central Repository? Is it possible to login from designer?