CAMSDATA Technologies India Interview Questions, Process, and Tips

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...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 erro...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.

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