Відео

Power BI testing means ETL testing What is the difference between Power BI testing and ETL Testing please tell sir.

Excellent

Super sir.. pls share pdf as well for better understanding

how to automate etl testing ? If I want to become etl automation tester what to learn?

hello sir, I have some questions. 1)how to test data if source (Oracle) and target(Sqlserver) are different databases? how we can connect them? 2) how to validate data flat file vs Table or Table vs flat file? 3) could you please make a practical video on parameter file which we use in the ETL project? why we use parameter file ? 4)could you please make a video on hadoop bigdata testing?

fees

need a document

in your last example you said the guy who joined in December 1981 will be senior to the guy who joined in May ? How ? the person who joined in May should be senior.

Will you please share this notes sir ??

Just know I watched this video. The way you explain the topic is awesome.

hello Sir, I have a question for SCD2 data validation for historic record. select empid,ename,salary,effective date, location from source where loc ='US' minus select empid,ename,salary,effective date, location from target where loc ='US' and active_flag = 'N' source doesn't hold the historic record then how we can validate Target data with Source.

interviewer asked me 'how to validate incremental load'

Hi sir I want to take the sql classes Do you teach sql?

Where is Unix

Hello Sir, Sometimes interviewer asks about historical load. What is historical load? could you please tell us?

how to answer therotically 'how to validate incremental load'

Nice Leacture Thank you sir 🙏👌👌👌👌

Mediocre... Please read till end maybe it will help you to not get loose your HARD EARN money like me on this fake institute. I edited my review after 5 to 6 months. I just want you tell you guys that there are better institutes than VTS that will provide you a real time knowledge. Here you get only theoretical knowledge. I will share my story with you guys about VTS I joined class in month of December and he charged me a fees of 25k and duration is around 40 days. So he first start with SQL he finished it in 10 to 15 days after that he forced you to give feedback/review about his institute on google. Once you guys done with your feedback then his shity journey starts where he starts with ETL which he don't have a real time knowledge and BI report testing where he give you only overview but no handson. One point I have to mention here that he takes a demo session before joining the class in that session he explain you about syllabus where he talk about cloud project we will provide you two real time project but g***ta he will give you only one project (Lord & Taylor) if you guys get same project that i have please reply to this review. He never told you about a project flow that most of my batchmates are still dont know how to explain the project in interview also he dont have any knowledge about Jira tool most of the organization follow jira model. And one of the most important point is that after completing SQL syllabus he start ETL so in every lecture I asked him about the class frequency for ETL so his answer is fixed we have more than 300 clients so you will get calls from our HR team but trust me guys I dont get any call from his fake HR team still am waiting for call😂😂😂. so please dont refer about this institute to your friends and family you will get better real time knowledge than this shity institue in less than 15k. Thanks for reading the review till end hope this will help you.

Thank you for valuable information

fees?

Can we automate bi report testing ? Is this possible

When you start new batch sir

Hi sir 1.How to eliminate duplicate salary 2. To fetch the emp who are all getting salary between 10000 and 15000 using 2 methods

Thank u sir 🙏

Hi Sir, Can I get the whole notes for ETL testing (document). It will be easy for others to go through and understand better.

Sir we are two student and want to join the class

Hi What tool i need to use to test the UI interface of Power BI reports ?

Would you please tell me the Etl testing integration validation Types or methods Tell me if you don't mind, please.

Would you please tell me the Etl testing integration validation Types or methods Tell me if you don't mind, please.

1 how you rate yourself in SQL 2 what are joins. 3 what are sub-queries 4 what is the difference between delete drop and truncate S what is a view 6 what is @ stored procedure. & what is correlated sub-queries 9 what are data types in safe and what is the difference between char and varchar 10 what s the difference between group function and scalar function what are the types of group functions 11 Can you write the duplicate query or Can you write a query to find out the duplicates 12 Write a query to delete the duplicate. 13 10 display second maximum salary 14 10 tables to join 15 views or left out join or right outer join 16 1o display alternate record 17 display the details of the employee earning the first maximum salary 18 what s the difference between rank () and dense_rank() 19 what s referential integrity constraint error 20 what is the difference between a primary key and a unique key 21 how 1o get 6 record from table 22 how 10 get first recond from o table. | 23 what s the difference between rownum and rowid 4 t t what is a function?

Osm Explanation

Very helpful video, can you please share the document

offline class is there?

Sir from where i can get this vm_for_t.rar file?

Incremental load .... What a great explanation .vah vah

Great one, that's one i wants

I gone through some ETL validation videos but your video are very clear and easy to understand sir. Thank you for posting this!

Very nice sir....very helpful

Sir, can you upload a video on SCD types with test design technique in real time scenario

Hi Sir, I like the way you explain its really helpful I want to enroll in your class for ETL testing can you let me how can i enroll

Hi i need answers for below question please help me out *) how to validate flat file in landing area. 1. How to validate data and quality between landing and stage area if source is flat file and stag is db with out converting flat file to any other format. 2. lf json file has millions of record and this is source file and target is oracle table then what is your approach to validate and how to validate 3. lf oracle database is source and Teradata is Target and millions of record then how to compare without using any automation tool and not with sample data, need to validate full load data

Sir plz share notes pdf

Good Channel for beginners 👍🏻

Sir can you please tell what is etl job?

Thank you for sharing this information sir.

Interview question? Can you ans sir? There is an application for which the input is a huge CSV file with millions of data in it and the file cannot be opened. There are some transformation logic applied to the data and also few business rules are applied and then the data is finally viewed in a UI application through some reports or tables. So how do u test the application. What are steps that you follow.

ρяσмσѕм