It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more. ...... More »
OLAP - On-Line Analytical Processing. Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.
This is a process guesstimate - the interviewer wants to know if you know what questions to ask. First, you would find out the dimensions of the building (height, weight, depth). This will allow you to determine the volume of the building. Does it...... More »
A "universe" is a "Business object" terminology. Business objects also happens to be the name of the company. The universe is the interfacing layer between the client and the datawarehouse . The universe defines the relationship among the various ...... More »
You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can a...... More »
This is something of a trick question, and was recently received by a Goldman candidate. The first thought of many people is to say 90 miles an hour, but consider: If you have done a lap at 30 miles an hour, you have already taken two minutes. Two...... More »
If you can't think of any, you're in the same boat as the unfortunately tongue-tied recent candidate at Salomon Smith Barney. Find one and remember it. ...... More »
Three. Let's see - if the first one is one color, and the second one is the other color, the third one, no matter what the color, will make a matching pair. Sometimes you're not supposed to think that hard. ...... More »