Clover Infotech Interview Questions, Process, and Tips

Q1. About your self
Add your answer

Q1. Experience in your job profile
Add your answer

Basic online aptitude test easily clear

Q1. Java based question
Add your answer

Q1. Procedure function difference
Ans. 
Procedures are a set of instructions executed sequentially, while functions return a value and can be called multiple times.
• Procedures are used to perform a set of instructions in a specific order.

• Functions are used to return a value and can be called multiple times.

• Procedures do not return a value, while functions do.

• Functions can have parameters, while procedures may or may not have parameters.
Answered by AI
Add your answer
Q2. Case decode difference
Ans. 
Decode and Case are SQL functions used for manipulating data.
• Decode is used to replace a value with another value based on a condition.

• Case is used to perform conditional logic and return a value based on the condition.

• Decode is specific to Oracle databases while Case is more widely used.

• Example of Decode: SELECT DECODE(column_name, 'value1', 'replacement1', 'value2', 'replacement2', 'default')

• Example of Case: SELECT C...read more
Answered by AI
Add your answer

Q1. Basic oops mvc sql, c#
Add your answer
Q2. What is the feature of opps
Ans. 
OOPs feature is encapsulation, inheritance, and polymorphism.
• Encapsulation: bundling of data and methods that manipulate the data within a single unit.

• Inheritance: ability of a class to inherit properties and characteristics from its parent class.

• Polymorphism: ability of objects to take on many forms or have multiple behaviors.

• Examples: Java, C++, Python, Ruby, etc.
Answered by AI
Add your answer

Q1. What is procedure in odi
Ans. 
A procedure in ODI is a set of instructions or actions that are executed in a specific order to perform a specific task.
• A procedure in ODI is created using the ODI Studio interface.

• It can be used to perform various tasks such as data integration, data transformation, and data loading.

• Procedures can be scheduled to run at specific times or triggered by events.

• They can include multiple steps or actions, such as extractin...read more
Answered by AI
Add your answer
Q2. What is mapping in odi
Ans. 
Mapping in ODI is the process of defining the relationship between source and target data structures.
• Mapping involves specifying the transformation rules to be applied to the source data.

• It determines how the data will be extracted, transformed, and loaded into the target structure.

• Mappings can be created using ODI's graphical interface or by writing code in ODI's declarative language.

• Mappings can include various trans...read more
Answered by AI
Add your answer
Q3. What is package in odi
Ans. 
A package in ODI is a container that holds related objects and components for organizing and managing data integration processes.
• Packages are used to group together related objects such as interfaces, procedures, variables, and more.

• They provide a way to organize and manage data integration processes in ODI.

• Packages can be used to define the execution order of objects within a process flow.

• They can be scheduled for aut...read more
Answered by AI
Add your answer
Q4. What is scd in odi
Ans. 
SCD stands for Slowly Changing Dimensions. It is a technique used in ODI to handle changes in data over time.
• SCD is used to track and manage changes in dimension tables

• It helps in maintaining historical data and tracking changes in attributes

• There are different types of SCDs, such as Type 1, Type 2, and Type 3

• Type 1 SCD overwrites the existing data with the new data

• Type 2 SCD creates a new record for each change and ma...read more
Answered by AI
Add your answer

Q1. How much salary you expected
Add your answer

Q1. Tell me about yourself and technical background.
Ans. I have given self introduction with educational and given brief about my technical work.
Answered Anonymously
Add your answer

Q1. Asked about windows platform like Active directory, patch management & Visualization.
Ans. I have explained brief about AD WSUS and Hyper V.
Answered Anonymously
Add your answer