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.

Thanks

💯 sir thank you

Helpful...

@etlqalabs5048

2 жыл бұрын

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

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

@etlqalabs5048

2 жыл бұрын

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

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

@etlqalabs5048

2 жыл бұрын

Select empid||empname as empDetails , mgrid||mgrname as managerDetails from emp It's simple, not sure if i understand your question

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

@etlqalabs5048

2 жыл бұрын

That's right . It’s case sensitive and when it doesn’t find the match it returns the 0

Please do video on all type of validation ,how to do count,minus all types of validation

@etlqalabs5048

2 жыл бұрын

Please do watch my recent upload. I have covered there. Hope that helps

Please make video on table validation and how to analyse if we found mismatch between source and target

@etlqalabs5048

2 жыл бұрын

Please do watch my recent upload on real time mini project

Please make vedio on table validation in database...

@etlqalabs5048

2 жыл бұрын

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 .

Can you please explain agile methodology sir ..thanks in advance

@etlqalabs5048

2 жыл бұрын

Please do watch recent upload . Hope you get insights in agile methodology

Display list of employees having first name David or diana without using like, or, operator hint(any/ all operator)

@etlqalabs5048

2 жыл бұрын

Hi , please share me some example for both of your questions

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

@waseemAkram-qc2vm

2 жыл бұрын

Yes sir we want this video

@etlqalabs5048

2 жыл бұрын

Please watch my recent upload . I have covered some information there.hope that be helpful

Please take example and show how to do validation and all kind of bug

@waseemAkram-qc2vm

2 жыл бұрын

Yes we need one video

@etlqalabs5048

2 жыл бұрын

Please do watch my recent upload on mini real time project.

@waseemAkram-qc2vm

2 жыл бұрын

@@etlqalabs5048 thanks for uploading