10+ Protiviti India Member Interview Questions and Answers

Lookup will fail if the memory is not sufficient to handle the increased record count.

• Lookup transformation caches the lookup table in memory

• If the memory is not sufficient, the lookup will fail

• Increasing the cache size or using persistent cache can help avoid failure

Finding a file name with the word 'Virus' in UNIX directory.

• Use the 'grep' command to search for the word 'Virus' in the directory.

• Use the '-w' option to match the complete word 'Virus'.

• Use the '-l' option to print only the file names that contain the word 'Virus'.

SCD Type 2 in Informatica can be achieved using multiple transformations.

• Use a Source Qualifier transformation to read data from the source.

• Use an Expression transformation to derive new columns or modify existing ones.

• Use a Lookup transformation to look up data in a reference table.

• Use a Router transformation to route data to different targets based on conditions.

• Use a Filter transformation to filter out unwanted data.

• Use a Sequence Generator transformation to generate surro...read more

Improving aggregator performance and understanding incremental aggregation.

• Optimize database queries and indexing

• Reduce data processing time by parallelizing tasks

• Use caching to reduce redundant data retrieval

• Incremental aggregation involves updating only new or changed data instead of processing all data again

• Example: Updating a daily sales report with only new sales data instead of recalculating the entire report

Hash join is a type of join used in database management systems. Pragma exception is used to handle exceptions in PL/SQL.

• Hash join is used to join large tables efficiently by creating a hash table of one table and scanning the other table.

• Pragma exception is used to handle exceptions in PL/SQL by specifying the action to be taken when an exception occurs.

• Examples of actions that can be specified include raising an error, logging the error, or continuing with the next statemen...read more

Procedures do not return values while functions return values.

• Procedures are used to perform an action while functions are used to calculate and return a value.

• Functions have a return type while procedures do not.

• Functions can be used in expressions while procedures cannot.

• Functions can have input parameters while procedures can have both input and output parameters.

Project management involves planning, organizing, and overseeing resources to achieve specific goals within a defined timeline.

• Creating project plans and timelines

• Assigning tasks and responsibilities to team members

• Monitoring progress and making adjustments as needed

• Communicating with stakeholders and team members

• Managing budgets and resources

• Ensuring project goals are met on time and within budget