Interview Questions

Business facts or measures and foreign keys are persisted in fact tables which are referred as candidate keys in dimension tables. Additive values are usually provided by the fact tables which acts as independent variables by which dimensional attributes are analyzed.

Attributes that are used to constrain and group data for performing data warehousing queries are persisted in the dimension tables.

An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard.

A query is a statement that returns a record-set.

Shipment movement information is captured each time a tracking label is scanned in the UPS delivery system. There may be several days between scans if the shipment is going cross-country or moving between countries.

Destination Scan: The shipment has arrived at the local UPS facility responsible for final delivery.

Arrival Scan: The shipment has arrived at a UPS facility.

Departure Scan: The shipment has departed a UPS facility and is on its way to the next UPS facility.

Origin Scan: UPS has received the shipment.

In contrast to investment, consumption is relatively stable.

Reserved words are words that cannot be used as object or variable names in a Java program because they're already used by the syntax of the Java programming language.

Java reserved words are keywords that are reserved by Java functions or other uses that cannot be used as identifiers (e.g., variable names, function names, class names).

If a reserved word was used as a variable you would get an error or unexpected result.

Examples : Int, Long, Abstract, Class, Break, Catch, Case, Public, Static, Void,...

The mapreduce framework contains most of the key architecture principles of cloud computing such as:

- Scale: The framework is able to expand itself in direct proportion to the number of machines available.

- Reliable: The framework is able to compensate for a lost node and restart the task on a different node.

- Affordable: A user can start small and over time can add more hardware.

The purpose of this question is to check your adaptability and flexibility. Did you feel victimized?

Answer this question by mentioning the change that was made but the main focus should be on how you adjusted in that situation and the results you achieved afterwards.

For example you can say something like, “Being an early joiner in the marketing team, I opened a lot of new customer accounts. Over the time the team grew and we had more people in the team opening more accounts. At one point of time, we had to re-distribute the accounts area wise so that a particular territory can be allotted to each one of us. This re-distribution meant loss of my high performing accounts and a requirement to develop new accounts in the assigned territory. Initially, it looked difficult but I could understand the need for this re-distribution and saw more opportunities for the company and myself. I introduced my colleagues to the old accounts I held and started strategizing for better ways to tap the new territory. Within 6 months, I could develop 50 new accounts with the help of new strategy. Usually we would achieve this result in 9 months to a year.”