TCS IT Analyst 1 Interview Questions and Answers

Answering the result of normal, left and right outer join of two tables with one column and same values for three rows.

• Normal join will return three rows with the same value in the column

• Left outer join will return three rows with the same value in the column and one additional row with null value in the second table

• Right outer join will return three rows with the same value in the column and one additional row with nu

Indirect file loading is a process of loading data from a file that is not directly connected to the target system.

• Indirect file loading involves using an intermediate file to load data into the target system.

• This method is useful when the source file is not compatible with the target system.

• Indirect file loading can be achieved using Informatica's indirect file method or by using a custom script.

• Examples of indirect f...read more

IDOC is a SAP intermediate document used for exchanging data between systems.

• IDOC stands for Intermediate Document.

• It is used for exchanging data between SAP systems or between SAP and non-SAP systems.

• IDOCs can be sent and received through various communication methods such as FTP, HTTP, and SMTP.

• IDOCs can be customized to meet specific business requirements.

• Examples of IDOCs include purchase orders, invoices, and deli