Real-Time Scenario in SQL for ETL Tester: Explained Step-by-Step

[@malavep389]

you have lot of patience RR, you are the best in explaining, awesome in teaching.

[@srtechnologiesravindraredd5303]

Thank you 😊

[@Soniab960]

You are the best in explaining.

[@srtechnologiesravindraredd5303]

Thank you

[@SANJAYYADAV-hm2bs]

Yours content are best Rabindra sir.

[@bhavani-vu6kg]

Hi sir,Today I have attended Infosys Interview in which they asked most of the questions that are covered in SQL playlist 1.Explain about SCD's 2.use of coalesce 3.Write Innerjoin query 4.How to get unique records from table 5.Get the count of employees department wise(Columns : Employee,Department) 6.Name Salary Ram 500 Ram 600 Ram 700 Ravi 2000 Ravi 5000 output should be Name Salary Ram 500,600,700 Ravi 2000,5000 7.Millons of records between two different databases how you validate

[@kumaroracle1069]

With how many experiance you have attended

[@SANJAYYADAV-hm2bs]

select c5, case when (length(c5)-length(replace(c5,'.','')))=2 then substr(c5,instr(c5,'.',1,1)+1,instr(c5,'.',1,2)-1-instr(c5,'.')) when (length(c5)-length(replace(c5,'.','')))=1 then substr(c5,1,instr(c5,'.')-1) when (length(c5)-length(replace(c5,'.','')))=0 then c5 END as Domain_name from jan20; Its a good example of multiple functions like- substr(), Instr(), replace(), length() and case statements.

[@sushanthkumar674]

Sir please let me know whether the answer is correct or not? SELECT SUBSTR(INPUT,CASE WHEN INSTR(DOMAIN_NAME,'.',1) THEN INSTR(DOMAIN_NAME,'.',1)+1 ELSE 1 END,LEN(DOMAIN_NAME) AS DOMAINNAME FROM ( SELECT SUBSTR(DOMAIN_NAME,1,(CASE WHEN INSTR(DOMAIN_NAME,'.',1,2) THEN INSTR(DOMAIN_NAME,'.',1,2)-1 ELSE INSTR(DOMAIN_NAME,'.')-1 END)) AS DOMAINNAME FROM DOMAIN )

[@ReadAloudStoryTime2]

Can we use split function ?

[@srtechnologiesravindraredd5303]

Yes

[@bhavani-vu6kg]

Hi Sir can you provide the query for the below question Table1 Col1 Col2 Col3 Table2 Col1 Col2 Col4 use union query for Table1 and Table2

[@srtechnologiesravindraredd5303]

In simple query Select col1,col2,col3 from table1 Union Select col1,col2,col3 from table2; It's a simple union.. still if you have doubts contact us..

[@sivasankar7013]

Hi sir Your r creating donain_table and u r inserting into donain_table How u can execute insert in to domain_table and how also u can execute select * from dual, Can u explain a bit slower

[@srtechnologiesravindraredd5303]

Check the insert all command...

[@sachinsachu7937]

Hai sir if this question asked in any of the interview can we explain and solve it by using decode function or case statement which is more easier ? Or this should be the best approach that I can go and impress the interviewer?😅

[@srtechnologiesravindraredd5303]

You can go with case statement..reason is it is having more options like like handling more comparison operators and as well as you can handle even null values as well..

[@sachinsachu7937]

@@srtechnologiesravindraredd5303 thanku 😊🙏🏻

[@devarajr3171]

Sir is it correct or not for below query, let me know... Select rownum, substr(substr(string,instr(string, '.', 1,1)+1), 1, instr(substr(string,instr(string, '.', 1,1)-1)) domain from tab where rownum

[@srtechnologiesravindraredd5303]

Logic should be dynamic not static..