Shelton Interview Questions and Answers

Find employee details with max salary in each department.

• Group employees by department

• Find max salary for each group

• Join with employee details to get employee info

Informatica Router and Union are used for data integration and transformation.

• Informatica Router is used to route data based on certain conditions.

• Informatica Union is used to combine data from multiple sources.

• Router can be used to split data into multiple targets based on conditions.

• Union can be used to merge data from multiple sources into a single target.

• Router can be used to implement complex data flows.

• Union can be used to eliminate duplicates from the data.

Dimensions and facts are two types of data in a data warehouse. Dimensions are descriptive attributes while facts are measurable data.

• Dimensions are used to categorize and filter data while facts are used to perform calculations and analysis.

• Dimensions are often used as the basis for reports and dashboards while facts are used to provide the underlying data.

• Examples of dimensions include time, location, and product while examples of facts include sales revenue, units sold, an...read more

Current trends in interest rates are influenced by economic conditions and central bank policies.

• Interest rates are currently low due to the economic impact of the COVID-19 pandemic.

• Central banks, such as the Federal Reserve, have implemented stimulus measures to support the economy.

• Long-term interest rates are expected to remain low as central banks maintain accommodative policies.

Static methods cannot be overridden in Java.

• Static methods belong to the class itself, not to any instance of the class.

• They cannot be overridden as they are resolved at compile-time based on the class they are called on.

• However, it is possible to hide a static method in a subclass by declaring a method with the same name and signature.

• This is known as method hiding.

Exception handling in Java is a mechanism to handle runtime errors and prevent program crashes.

• Use try-catch blocks to handle exceptions

• Use finally block to execute code regardless of exception

• Use throw keyword to manually throw exceptions

• Use throws keyword in method signature to declare exceptions that can be thrown