Interview Questions

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.

Overridden methods must have the same name, argument list, and return type (i.e., they must have the exact signature of the method we are going to override, including return type.)

The overriding method cannot be less visible than the method it overrides( i.e., a public method cannot be override to private).

The overriding method may not throw any exceptions that may not be thrown by the overridden method

Following are the 3 core directives of AngularJS.

1. ng-app : This directive defines and links an AngularJS application to HTML.


2. ng-model : This directive binds the values of AngularJS application data to HTML input controls.


3. ng-bind : This directive binds the AngularJS Application data to HTML tags.

Hub is device to connect two devices, switch is a network bridge which processes and routes data approirately over network layer of OSI Reference model

MapReduce is a software framework that was created by Google. It`s prime focus was to aid in distributed computing, specifically large sets of data on a group of many computers. The frameworks took its inspiration from the map and reduce functions from functional programming.

The following are the ways of initiating a CICS transaction.

1. By entering Transaction Id

2. By Start command

3. By Return Trans Id (as in pseudo - conversation)

4. By Registering Tran ID in plt so that it will be automaticaly dusring CICS start

5. By ATI (Automatic task initiation)

6.PF & PA keys as defined in PCT

If you're attempting to give an answer that is as unrevealing as possible, try something like this:

  " I have been a dedicated,loyal,hardworking employee throughout my career and nothing in my personal life-family obligations, hobbies, or volunteer work-has ever affected my performance. Nor would I ever expect it to."