Thanks for clearing my doubt sir. No one there for me to clarification. U r the only hope to understand my questions. Really am saying on your channel only am learning ETL Testing. It's very much helpful to me.
In this session , when we use Instr for emp table like … let’s consider Query:- Select INSTR(‘ANDREAS’ , ‘a’,1,1) from dual ; It return 0 Because that ‘a’ is case sensitive that’s why not counting if we give ‘A’ then it will take count and return 1. In Mayank name a is small letter that’s why taking 1st occurrence is at 2nd position that’s why return 2 Correct me if I am wrong
Simply do => Select SUBSTR(‘Mayank’,2,1) || SUBSTR(‘Mayank’,4,1) from Dual ; Result :- aa U can also try on actual table Select SUBSTR (ename,2,1) || SUBSTR (ename,4,1) from employees; Result for Mayank is => aa
Yes this is static solution and generally not a practical requirement . You generally need a solution that works for a variety of data within that column hence I have used instr function to locate the occurrence of 2 occurrence and extracted . So query may like this - find all the values in ename who are having 2 or more a’s . Just an example . Hope this clarifies
Please watch my recent upload which covers relational target validations and also quite of other videos in the ETL Testing playlist covers these validations . Do let me know if you have any specific points to cover .
Sir can you make a video on how to write test scenarios and test cases in ETL. And sir one more thing video on LEFT side is not visible clear.thank you so much for valuable guidance and knowledge
Display empid, emp fullname in one column and his manager -id, manager fullname in another column eg(employeeid_employee name) (managerid, managername) concact in single query
Thanks for clearing my doubt sir. No one there for me to clarification. U r the only hope to understand my questions. Really am saying on your channel only am learning ETL Testing. It's very much helpful to me.
💯 sir thank you
Please make video on table validation and how to analyse if we found mismatch between source and target
Please do watch my recent upload on real time mini project
Please do video on all type of validation ,how to do count,minus all types of validation
Please do watch my recent upload. I have covered there. Hope that helps
Can you please explain agile methodology sir ..thanks in advance
Please do watch recent upload . Hope you get insights in agile methodology
In this session , when we use Instr for emp table like … let’s consider
Query:- Select INSTR(‘ANDREAS’ , ‘a’,1,1) from dual ;
It return 0 Because that ‘a’ is case sensitive that’s why not counting if we give ‘A’ then it will take count and return 1.
In Mayank name a is small letter that’s why taking 1st occurrence is at 2nd position that’s why return 2
Correct me if I am wrong
That's right . It’s case sensitive and when it doesn’t find the match it returns the 0
Please make video on how to do validation in database and how to come to know that this is bug and how to analyse that bug
Yes sir we want this video
Please watch my recent upload . I have covered some information there.hope that be helpful
Simply do =>
Select SUBSTR(‘Mayank’,2,1) || SUBSTR(‘Mayank’,4,1) from Dual ;
Result :- aa
U can also try on actual table
Select SUBSTR (ename,2,1) || SUBSTR (ename,4,1) from employees;
Result for Mayank is => aa
Yes this is static solution and generally not a practical requirement . You generally need a solution that works for a variety of data within that column hence I have used instr function to locate the occurrence of 2 occurrence and extracted . So query may like this - find all the values in ename who are having 2 or more a’s . Just an example . Hope this clarifies
Please make vedio on table validation in database...
Please watch my recent upload which covers relational target validations and also quite of other videos in the ETL Testing playlist covers these validations . Do let me know if you have any specific points to cover .
Helpful...
Keep watching
Sir can you make a video on how to write test scenarios and test cases in ETL. And sir one more thing video on LEFT side is not visible clear.thank you so much for valuable guidance and knowledge
Display empid, emp fullname in one column and his manager -id, manager fullname in another column eg(employeeid_employee name) (managerid, managername) concact in single query
Select empid||empname as empDetails , mgrid||mgrname as managerDetails from emp
It's simple, not sure if i understand your question
Please take example and show how to do validation and all kind of bug
Yes we need one video
Please do watch my recent upload on mini real time project.
@@etlqalabs5048 thanks for uploading
Display list of employees having first name David or diana without using like, or, operator hint(any/ all operator)
Hi , please share me some example for both of your questions
Thanks