As someone who has interviewed hundreds upon hundreds of people, I’ve learned the idea is not to “stump” then interviewee. In other words “pop quiz” questions like “What is a union vs join” only shows the interviewee has studied potential questions (at the least). Instead, I have learned to actually get to know the interviewee. What has he or she enjoyed during their career, what challenges have they faced etc. I also explain the role in detail and get a sense it the candidate is a good fit. Above all, I look for TALENT. Meaning the interviewee might not recall off-hand the difference between a Dimension and Fact table, but it’s something I can teach him in 10 minutes and he end up being a rock star employee.
Hi Sir, I pretty much enjoy this video but there is one mistake in one of your answer. Difference between varchar and varchar2. Answer which you given is difference between char and varchar. Both varchar and varchar2 are variable character data types so both datatypes will stopre 60 bytes of memory in your example. The main difference between varchar and varchar2 is very simple. In varchar null value and empty string is different values however in varchar2 both values are same. So oracle reserved Varchar datatype for future if in any case null and empty string will be decided as equal. Sound stupid to create two datatypes for small reason but its true. :)
For 10th swap row values , Select Eno,Ename, Case when Eno = 1 then ‘blore’ Else ‘hyd’ End as loc from Emp ; this query will display as we want the results
Please re-check varchar vs varchar2 ... what u have mentioned is char vs varchar.... please check internal vs external datatypes as well, to understand varchar vs varchar2
Question 26. We can also do it by using last-day function.. Example Select * from table name Where hire-date = (select last-day(sysdate) from dual) Also we can do it by using Trunc() function
staging is a storage area between source and target ...It is mainly used for transformation as per the mapping......first data is moved from source or OLTP to staging area and transformation is done on the data and then after the transformation data is mover from staging to data warehouse....
Thanks a lot it is a great help to me, appreciate you for publishing such useful stuff!!
As someone who has interviewed hundreds upon hundreds of people, I’ve learned the idea is not to “stump” then interviewee. In other words “pop quiz” questions like “What is a union vs join” only shows the interviewee has studied potential questions (at the least).
Instead, I have learned to actually get to know the interviewee. What has he or she enjoyed during their career, what challenges have they faced etc.
I also explain the role in detail and get a sense it the candidate is a good fit.
Above all, I look for TALENT. Meaning the interviewee might not recall off-hand the difference between a Dimension and Fact table, but it’s something I can teach him in 10 minutes and he end up being a rock star employee.
Very logical and systematic explanation,thanks a ton for providing such great clarity.🙏🙏
hello sir..
I have seen all video lecture. I think its very useful for me.I want say only that you are doing great job.
Its very useful and u explanation very well
@33:42 that will not work... at least not in SQL Server; you cannot have an aggregate function inside of another one.
really a very good piece of information....thank you for sharing
Nice
This is Gold!
Hi Sir,
I pretty much enjoy this video but there is one mistake in one of your answer. Difference between varchar and varchar2. Answer which you given is difference between char and varchar. Both varchar and varchar2 are variable character data types so both datatypes will stopre 60 bytes of memory in your example.
The main difference between varchar and varchar2 is very simple. In varchar null value and empty string is different values however in varchar2 both values are same. So oracle reserved Varchar datatype for future if in any case null and empty string will be decided as equal. Sound stupid to create two datatypes for small reason but its true. :)
thanks for detailed explanation.
very helpful video
For 10th swap row values ,
Select Eno,Ename,
Case when Eno = 1 then ‘blore’
Else ‘hyd’
End as loc from Emp ; this query will display as we want the results
Answer for 10th qn:
SQL> select STDID
2 , greatest(maths,phy,che,telu) as HIGESTMARKS
3 from your_table
4 /
Very well explained *****
for 10 th question: we can use decode function for the location column.
Please re-check varchar vs varchar2 ... what u have mentioned is char vs varchar.... please check internal vs external datatypes as well, to understand varchar vs varchar2
Answer for the 10th question is by using the case statement on the LOC column.
ya thank you sir but there may be number of different records in LOC at the time what we do??
Question 26. We can also do it by using last-day function..
Example
Select * from table name
Where hire-date = (select last-day(sysdate) from dual)
Also we can do it by using Trunc() function
For column count no need to write case statement
is SSIS is an ETL tool? can we mention SSIS as ETL tool in our Resume?
Can you please tell more about source to staging and staging to warehouse validations.I'm asking you about queries and validations we do.Thanks!
Good explanation.Thanks
I am interested in getting trainig of ETL testing
How do we get builds from the developers and how do we send the builds to the clients after deployment
i have one question
how much data generally coming for daily opertion in insurance domain etl project
14M per day.
What is staging in etl testing?
staging is a storage area between source and target ...It is mainly used for transformation as per the mapping......first data is moved from source or OLTP to staging area and transformation is done on the data and then after the transformation data is mover from staging to data warehouse....
in stagging we are applied business logic and all the data development activites happen in stagging area
Delhi
What is the name of the instructor?
🙏
Etl testing WhatsApp group number pls
For experienced
hey, did you find any zap or telegram group?
Answer for question 11. You can use ALL_TAB_Columns in Oracle can queried. Select Table_name from ALL_TAB_COLUMNS where COLUMN_NAME = ''Çolumn Name''
You got that right!
Thanks!
L> SELECT COUNT(*) FROM ALL_USERS;
COUNT(*)
--------
27
This guy did not answer most of the question. He was not sure on most of these questions.
Completely messed up the last question.