Master you are so genius learning a lot of things from you. You are my path shower. Thanks a lot

Just awesome, please upload the second part ASAP.

Thank you 🙏

Thanks sir

sir i have a doubt here. can we use order by clause in a subquery?

Hello sir will you plz make some videos on talend tools

Hello sir, please explain Normalization in details..

sir...If possible teach snowflake in etl testing perspective plzzzz.......

@etlqalabs5048

2 жыл бұрын

Ok - will do a video on star and snowflake design pattern

Sir explain end to end etl testing proj in health care domain

@etlqalabs5048

2 жыл бұрын

There is a demo project that i have covered starting from requirements till testing in ETL Testing playlist and Don't worry about domain. ETL testing or development is agnostic to any domain, it doesn't play much role with regards to testing and also there are various areas and components in any domain like BFSI or healthcare so knowledge of business is important to know but it's not really have much impact specially for testing

Which will be better to use in a interview; rank(), dense_rank or row_number?

@etlqalabs5048

Жыл бұрын

These are different approach to solve the problem, it's better to explain more than one solutionsl approach which shows your in-depth understanding towards the problem. Rank() function is used when we don't have any duplicate data and dense_rank() can be used even if you have dupes. Hope this clarifies

which are the common column in mapping sheet

@etlqalabs5048

2 жыл бұрын

If you check the mapping sheet in the test case video, it's quite evident in the sheet which columns from source to next stages are mapped/linked . Not sure if i understand your question. Give more elaborative details if not.

@sharadjogdand5332

2 жыл бұрын

@@etlqalabs5048 in mapping sheet, which are common column present in souce and target.

At which stage ETl tester work begin.

@etlqalabs5048

Жыл бұрын

Right from the inception of the project, tester must be involved in order to thoroughly test the application/system.