Technology 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.

 Test scenarios are derived from requirement documents. We follow each and every functionality (called business rules) mentioned in the requirement document. One functionality can have multiple business rules. For example, let us say in there is one requirement called “Login”. This “Login” may have various scenarios. For example, one scenario is, enter the right User ID and wrong password. The system should display an error message. Another scenario would be to enter wrong User ID and right Password. The system should display an error message. The third scenario could be to enter the right User Name and right Password. The system should allow the user to get into the system. This is how the test cases are derived from the requirement documents or from the Use Cases.

Exploratory testing: means testing an application without a test plan and test script. In exploring testing test explore the application on the basis on his knowledge. The tester has no knowledge about the application previously. He explores the application like an end user and try to use it. While using the application his main motive is to find the bugs which are in the application.

Specification-driven testing: means to test the functionality of software according to the user requirements. In this, tester inputs multiple data and monitors the outputs from, the test object. In this testing tester evaluate the showstopper bugs which break the major functionality of the application. This type of testing requires test plan and test.

To send data/info to group of computers using same network

•  NO_CACHE – It is used for not caching values.


•  PRE_LOAD_CACHE – Result column preloads and compares the column into the memory, prior to executing the lookup.


•  PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.


•  DEMAND_LOAD_CACHE – Result column loads and compares the column into the memory when a function performs the execution.


•  DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

Final method is a method defined in the super class with final modifier.

We cannot overriding final method of super class in the sub class.

EX:

 Class Sample {

   final void funOne() {

   }

   void funTwo() {

   }

}

Class Sub extends Sample {

  void funOne() { // overriding is not allowed

  }

  viod funTwo() { //overriding is allowed

  }

}

URI is known as Uniform Resource Identifier as it identifies the resources requested by clients and fetches them from the server. 

The components that are used in URI are as follows:

- http: is the first thing that is used in a URL and it is used to tell what kind of resource that needs to be retrieved over the server.

 This includes the server details and it is itself a protocol known as Hypertext Transfer Protocol (HTTP) that is used to fetch the information. 

- Web browsers sometimes use the secure protocol that is represented using HTTPs used in case of secure transaction over the internet. 

- FTP: is also a protocol that is known as File Transfer Protocol that allows the transfer from a file from local computer to server

Look for the existence of the following items:

- Generic Data Models

- An Enterprise Data Platform

- Identify the Data Sources

- Selection of a MDM Product

- Implementation of a Customer Master Index or appropriate alternative