Accenture Abinitio Developer Interview Questions and Answers for Experienced

Q1. What will be the output if input is MFS file , componenet is rollup with {} key
Ans. 
The output of a rollup component with {} key on an MFS file will be the aggregated values based on the specified key.
• The rollup component in Abinitio is used to perform aggregation operations on data.

• The {} key in the rollup component indicates that all records should be considered for aggregation.

• The output will contain the aggregated values based on the specified key.

• For example, if the MFS file contains student reco...read more
Answered by AI
View 2 more amswers
Q2. What will be the output if input is mfs file and component is dedup with {} key
Ans. 
The output will be a deduplicated mfs file based on the specified key.
• The dedup component in Abinitio is used to remove duplicate records from a dataset.

• The {} key in dedup signifies that all fields in the record are considered for deduplication.

• The output will contain only unique records based on the combination of all fields in the input mfs file.
Answered by AI
View 1 more amswer

Q1. What is jdk, string related questions, basic java oops questions?
Add your answer

Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
Ans. 
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
• Indexes are used to speed up data retrieval operations in a database.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are generally ...read more
Answered by AI
Add your answer
Q2. Write a query to delete duplicate rows from a table.
Ans. 
Query to delete duplicate rows from a table
• Use GROUP BY clause to group the rows by their unique values

• Use HAVING clause to filter out the groups with count greater than 1

• Use DELETE statement to delete the duplicate rows
Answered by AI
Add your answer
Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
Add your answer
Q4. What is a singleton pattern and how to implement it?
Ans. 
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
• Create a private constructor to restrict instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety if necessary

• Examples: Database connection, Logger, Configuration settings
Answered by AI
Add your answer
Q5. How do you handle exceptions in stored procedures?
Ans. 
Handle exceptions in stored procedures by using TRY-CATCH blocks.
• Use TRY-CATCH blocks to catch and handle exceptions

• Log the error message and severity level

• Rollback the transaction if necessary

• Rethrow the error if it cannot be handled

• Use RAISERROR to raise custom error messages
Answered by AI
Add your answer
Q6. Explain SOLID principles.
Ans. 
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

• I - Interface Segregation Principle: C...read more
Answered by AI
Add your answer
Q7. Difference between throw and throw exception?
Ans. 
throw is used to throw an exception while throw exception is used to throw a specific exception.
• throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

• throw exception is followed by the type of exception that needs to be thrown.

• throw can be used to throw any object while throw exception can only be used to throw an exception object.

• Example: throw new Exception("
Answered by AI
Add your answer

Corona how you survive

Q1. Tell me about your Self intro
Add your answer
Q2. Minimum knowledge on service now.
Add your answer

Q1. Salary and joining date
Add your answer

Q1. Hashmap, linkedlist, arraylist, collection interface
Add your answer
Q2. Small coding questions on collection interface
Add your answer

Q1. Managerial round, questions were on certain scenarios like production issues and how to handle them
Add your answer

Q1. Relocation, salary discussion
Add your answer

C and c++ and data structure

Q1. Question front Data structure, c++ and c
Add your answer

Q1. Ask all those questions that you want
Add your answer

Q1. What is Linux Boot Process ?
Ans. 
Linux Boot Process is the sequence of events that occur from power on to the login prompt.
• BIOS/UEFI firmware initializes hardware

• Bootloader loads kernel into memory

• Kernel initializes system processes and mounts filesystems

• Init process starts system services and user login

• Graphical user interface (GUI) or command line interface (CLI) is presented to user
Answered by AI
Add your answer
Q2. What is NIC Teaming ?
Ans. 
NIC teaming is the process of combining multiple network interface controllers to work as a single virtual NIC.
• NIC teaming provides redundancy and load balancing for network traffic.

• It can be configured in different modes such as switch independent, LACP, and static.

• NIC teaming is commonly used in server environments to improve network performance and availability.

• Example: Combining two 1 Gbps NICs to create a 2 Gbps v...read more
Answered by AI
Add your answer