Infosys BPM Technology Analyst Interview Questions and Answers

Q1. Explain completed project details
Add your answer

Q1. List the aggregate and window function in oracle
Ans. 
Aggregate functions perform calculations on a set of values and return a single value. Window functions perform a calculation across a set of table rows.
• Aggregate functions: SUM, AVG, COUNT, MAX, MIN

• Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD
Answered by AI
Add your answer
Q2. How to load flat file
Ans. 
To load a flat file, use a data loading tool or script to import the file into a database or application.
• Use a data loading tool like SQL Loader, Informatica, or Talend to load the flat file into a database.

• Write a script in a programming language like Python, Java, or Perl to read the flat file and insert the data into a database.

• Ensure the flat file is properly formatted and matches the schema of the database or appl
Answered by AI
Add your answer

High level English, Aptitude questions mcq based.

Q1. Project related questions were asked.
Add your answer