Пікірлер

• 
  @AnkitMankel28 күн бұрын

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

• 
  @STEAVEJOBS-kb3dxАй бұрын

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

• 
  @vaibhavrane99794 ай бұрын

  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?

• 
  @manishaunak94595 ай бұрын

  fees

• 
  @ranavikramsingh12344 ай бұрын

  Please message in whatsapp 8210139296

• 
  @user-hk3ee4so7p5 ай бұрын

  need a document

• 
  @screamlordopus7 ай бұрын

  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.

• 
  @maheshmahi91097 ай бұрын

  Will you please share this notes sir ??

• 
  @shamisyed92858 ай бұрын

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

• 
  @ranavikramsingh12347 ай бұрын

  So nice of you

• 
  @Vaibhao9 ай бұрын

  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.

• 
  @prajakta8879 ай бұрын

  interviewer asked me 'how to validate incremental load'

• 
  @ranavikramsingh12349 ай бұрын

  Yes using insert and update statement for more details you can text 8210139296

• 
  @MsRashrocks9 ай бұрын

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

• 
  @ranavikramsingh12349 ай бұрын

  yes please whatsapp me 8210139296

• 
  @ranavikramsingh12349 ай бұрын

  Hi , Can you please whatsapp and call me at this number 8210139296

• 
  @ranavikramsingh12349 ай бұрын

  can u please call or message me 8210139296

• 
  @chitammaharani855110 ай бұрын

  Where is Unix

• 
  @Vaibhao10 ай бұрын

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

• 
  @shamisyed92858 ай бұрын

  Historical load means full load only.

• 
  @Vaibhav...r8 ай бұрын

  ​@@shamisyed9285okay Thanks

• 
  @gauravmane928710 ай бұрын

  how to answer therotically 'how to validate incremental load'

• 
  @nilamnavgire222710 ай бұрын

  Nice Leacture Thank you sir 🙏👌👌👌👌

• 
  @user-et6xd3xc5p10 ай бұрын

  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.

• 
  @ShreeSwami-bq3gg11 ай бұрын

  Thank you for valuable information

• 
  @tusharaher877711 ай бұрын

  fees?

• 
  @ranavikramsingh123411 ай бұрын

  please WhatsApp 8210139296

• 
  @prajakta8879 ай бұрын

  @@ranavikramsingh1234 can you tell me the duration for etl testing course

• 
  @ranavikramsingh12349 ай бұрын

  @@prajakta887 Please whatsapp for details 8210139296 ,it takes 1.5 month

• 
  @ranavikramsingh12348 ай бұрын

  @@prajakta887 1.5 months you can whatsapp 8210139296 for more information

• 
  @utkarshnema931111 ай бұрын

  Can we automate bi report testing ? Is this possible

• 
  @nguyenkhoa77686 ай бұрын

  yes, there is one instruction in youtube for automate bi report testing

• 
  @jashuvajashu82711 ай бұрын

  When you start new batch sir

• 
  @ranavikramsingh123411 ай бұрын

  8210139296 please whatsapp

• 
  @chandrikalakshmikandan8895 Жыл бұрын

  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

• 
  @successbyshikha9952 Жыл бұрын

  Thank u sir 🙏

• 
  @ranavikramsingh1234 Жыл бұрын

  Most welcome

• 
  @swethab5614 Жыл бұрын

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

• 
  @ranavikramsingh1234 Жыл бұрын

  whatsapp number 8210139296

• 
  @pranaybadade6847 Жыл бұрын

  Sir we are two student and want to join the class

• 
  @ranavikramsingh1234 Жыл бұрын

  Hi Pranay, please call me also whatsapp me 8210139296

• 
  @ranavikramsingh1234 Жыл бұрын

  @Pranay please call or whatsApp me 8210139296

• 
  @ranavikramsingh1234 Жыл бұрын

  hi pranay can u please whatsapp me 8210139296

• 
  @ramyanive1349 Жыл бұрын

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

• 
  @ranavikramsingh1234 Жыл бұрын

  Manually we test the ui of bi report

• 
  @neethisurya9755 Жыл бұрын

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

• 
  @neethisurya9755 Жыл бұрын

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

• 
  @borhadeketan Жыл бұрын

  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?

• 
  @akashkarade9831 Жыл бұрын

  Osm Explanation

• 
  @ranavikramsingh1234 Жыл бұрын

  Thanks

• 
  @prithvipampana1492 Жыл бұрын

  Very helpful video, can you please share the document

• 
  @ranavikramsingh1234 Жыл бұрын

  These r paid documents

• 
  @AtharvShow Жыл бұрын

  Please share the documents, will pay if required

• 
  @English_raj2020 Жыл бұрын

  offline class is there?

• 
  @ranavikramsingh1234 Жыл бұрын

  Online only

• 
  @shrutiraut8497 Жыл бұрын

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

• 
  @ranavikramsingh1234 Жыл бұрын

  For this u need to join our training

• 
  @RamaKrishna-sf7jh Жыл бұрын

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

• 
  @ranavikramsingh1234 Жыл бұрын

  Keep watching

• 
  @ranjankumar1905 Жыл бұрын

  Great one, that's one i wants

• 
  @priyajamuna5403 Жыл бұрын

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

• 
  @ranavikramsingh1234 Жыл бұрын

  You r welcome priya

• 
  @nikitaghate9837 Жыл бұрын

  Very nice sir....very helpful

• 
  @ranavikramsingh1234 Жыл бұрын

  Thank you so much nikita...

• 
  @ranavikramsingh1234 Жыл бұрын

  Thank you so much Nikita

• 
  @SivaKumar-vm6iq Жыл бұрын

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

• 
  @cyrillapatricia4924 Жыл бұрын

  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

• 
  @ranavikramsingh1234 Жыл бұрын

  Please call or whatsapp me 8210139296

• 
  @ranavikramsingh1234 Жыл бұрын

  Hi Cyrilla,Please whatsapp or call in 8210139296 for more details about training

• 
  @theicongamer2761 Жыл бұрын

  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

• 
  @saurabh6814 Жыл бұрын

  Sir plz share notes pdf

• 
  @ranavikramsingh1234 Жыл бұрын

  Attend training 8210139296

• 
  @vinaykale5053 Жыл бұрын

  Good Channel for beginners 👍🏻

• 
  @ranavikramsingh1234 Жыл бұрын

  Thanks 🙂

• 
  @surajdeshmukh102 Жыл бұрын

  Sir can you please tell what is etl job?

• 
  @ranavikramsingh1234 Жыл бұрын

  we need to run the job after running job data gets loaded into the target(datawarehouse) this job which we run are etl jobs

• 
  @surajdeshmukh102 Жыл бұрын

  @@ranavikramsingh1234 sir it is same like etl code?

• 
  @ranavikramsingh1234 Жыл бұрын

  @@surajdeshmukh102 see etl code is written for the transformation logic to be used to load data from source to target but etl run is a specific workflow we select and run the workflow to load data from source to target

• 
  @surajdeshmukh102 Жыл бұрын

  @@ranavikramsingh1234 thankyou sir ... test scenario for full load and increamental load?

• 
  @ranavikramsingh1234 Жыл бұрын

  @@surajdeshmukh102 for that you can join our institute if you want-whatsapp number-8210139296

• 
  @sravanthi1210 Жыл бұрын

  Thank you for sharing this information sir.

• 
  @ranavikramsingh1234 Жыл бұрын

  Welcome!

• 
  @pujakandekar4173 Жыл бұрын

  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.

• 
  @ranavikramsingh1234 Жыл бұрын

  Puja, we will first have to create a temporary table. Load the data from the file into temporary table and once data is in temporary table we can do the validation..

• 
  @pujakandekar4173 Жыл бұрын

  @@ranavikramsingh1234 Ok Thank you so much sir.

• 
  @ranavikramsingh1234 Жыл бұрын

  @@pujakandekar4173 please whatsApp for any detailed answer 8210139296

• 
  @trace6284 Жыл бұрын

  ρяσмσѕм

• 
  @connect2right151 Жыл бұрын

  Hi sir...How to check data is consistent after cleansing..I am not able to answer this question in interview..please give ans

• 
  @My-Research Жыл бұрын

  Useful information