IT Analyst 1 Interview Questions and Answers for Freshers

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 null value in the first table

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 file loading include loading data from a mainframe system o...read more