Infosys Senior Analyst Interview Questions, Process, and Tips for Experienced

A pass through query is a SQL statement that is sent directly to a remote database server for processing.

• It is used to execute SQL statements on a remote database server.

• It is composed of a SQL statement and a connection string.

• It is useful for querying large datasets that are stored on a remote server.

• It can improve performance by reducing network traffic.

• Example: SELECT * FROM [ODBC;Driver={SQL Server};Server=myServe...read more

Merging data sets involves identifying common variables and combining them into a single dataset.

• Identify common variables between the datasets

• Ensure data types are consistent across datasets

• Use a join operation to combine the datasets

• Handle missing or duplicate data appropriately

• Perform data cleaning and preprocessing before merging

• Example: Merging customer data from two different sources based on customer ID

Without a run statement, the program will not execute any code.

• The program will not run any code written in the main function.

• If there are any functions called within the main function, they will not be executed.

• The program will terminate without any output or error message.

• The absence of a run statement may indicate an incomplete or faulty program.

SAS has equivalent functions to SQL joins such as merge, join, and concatenate.

• SAS merge function combines two or more datasets based on common variables.

• SAS join function combines two or more datasets based on common variables and can specify the type of join (inner, outer, left, right).

• SAS concatenate function stacks datasets on top of each other.

• Examples: merge dataset1 with dataset2 on variable ID; join dataset1 wi...read more