This was really helpful and would be very useful to start preparing for data engineer interviews. Thank you Apoorv for giving us an interviewer pov. Looking forward to more such content!
I have 2.7 years of experience in Salesforce development but I want to transition to data engineer. As per I know job opportunities and growth is more in data engineering compared to salesforce CRM. Actually I tried to get job in Salesforce but getting calls 2-3 per month it's been 6 months . I also worked 2 projects in service and experience cloud. Have skills like lwc, integration, admin, Apex, triggers, SOQL and SOSL. If I'm trying to transition to other I understood that CRM domain have less flexibility compared to data domain. So I need suggestions like is it good to change my domain to data side?????
Incase someone have doubts regarding joins she answered, her answers are right. All will have 6 records as output.
Yes, she is absolutely right😁
If you have same entity. Just multiply.
This was really helpful and would be very useful to start preparing for data engineer interviews. Thank you Apoorv for giving us an interviewer pov. Looking forward to more such content!
Great eye opener and great knowledge shared
Valuable insights. Helpful for me.
Great
Valuable insights appuu sir❤❤
Great questions....
Nice insights Apoorv.!
Very insightful 😃
Sir plz hav someone 10 + years guy interview...it will help a lot
I have 2.7 years of experience in Salesforce development but I want to transition to data engineer. As per I know job opportunities and growth is more in data engineering compared to salesforce CRM. Actually I tried to get job in Salesforce but getting calls 2-3 per month it's been 6 months . I also worked 2 projects in service and experience cloud. Have skills like lwc, integration, admin, Apex, triggers, SOQL and SOSL. If I'm trying to transition to other I understood that CRM domain have less flexibility compared to data domain. So I need suggestions like is it good to change my domain to data side?????
Please suggest a chennal for pyspark
What exactly are you looking to learn?
inner join ==3 records
Ideally it should be 6 records as you will get a matching record every single time😬
@@apoorvgupta1993 thanks Sir , so duplicate combinations also included
Yes, in sql we can definitely get duplicate records.. that’s why we have the DISTINCT keyword to get only the distinct records if we want
when i tried i got around 9 records for cross join kindly confirm it
Cross join with give at max 6 rows, means no. of rows on table 1* no. of rows in table 2
Please arrange an interview with more experience guy @sumit mittal