Assume We had a PAN india Retail store because of which i have customer table in backend one is customer profile table and other is customer transaction table both will linked with customer id so what will the approach to find the name of customer who will do the transaction ? which is computationally efficient to solve this left join or subquery ?

Question

Accepted Answer

Use left join for computationally efficient way to find customer names from customer profile and transaction tables.

Use left join to combine customer profile and transaction tables based on customer id
Left join will include all customers from profile table even if they don't have transactions
Subquery may be less efficient as it has to be executed for each row in the result set

Top TransOrg Analytics Data Engineer interview questions & answers

Popular interview questions of Data Engineer

Top HR questions asked in TransOrg Analytics Data Engineer