PROBLEM STATEMENT: Pivot the ‘Occupation’ column in OCCUPATIONS table so that each ‘Name’ is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers should be Doctor, …
PROBLEM STATEMENT: one of the conglomerate corporations just acquired some new companies. Each of the companies follows this hierarchy. Given the table schemas below, write a query to print …
PROBLEM STATEMENT: The Trips table holds all taxi trips. Each trip has a unique Id, while Client_Id and Driver_Id are both foreign keys to the Users_Id at the Users …
PROBLEM STATEMENT: Given a text file file.txt, transpose its content. You may assume that each row has the same number of columns and each field is separated by the …
Problem Statement: Given a text file file.txt that contains list of phone numbers (one per line), write a one liner bash script to print all valid phone numbers. You …
Write a bash script to calculate the frequency of each word in a text file words.txt. words.txt contains only lowercase characters and space ‘ ‘ characters. Each word must …
The Employee table holds all employees. Every employee has an Id, and there is also a column for the Department Id. ID Name Salary DepartmentId 1 Joe 85000 1 …
Read previous post: Informatica interview questions and answers-1 11. Can we use the mapping parameters or variables created in one mapping into another mapping? NO. We can use the …