Hi , an interviewer asked me "in your project at which stage SCD type 2 is implemented. Whether its SRC - Landing, OR Landing to Staging OR Staging to DW zone..?" could you please help
Hi Mam, Target par hone wale ye Full Load and Incremental load ke baare me ek confusion hai? Jaise ki Target me Dimension and Fact Table hote hai? jab data incremental load me jata hai to vo dimension or fact table me kis tarah se load hote hai? jo dimension table me SCD2 agar hota hai to kya vo incremental load ka hi part hai?
Very well explained mam. I've one question. Can we use "select * from stage_table" instead of select col1, col2, col3..... coln(uding all columns) from stage_table The reason is, if we have almost 100 columns, we can't write all together right. So, could you please give clarity on this? Thank you ❤
Complex se complex source sql query likhne ka tarika Complex Target Query likhne ka tarika Or dono complex Query ko kaise validate karte he ….Please Video bannayiye iss par
could u try to explain how to understand mapping document with real time examples, it would help me to more understand about the mapping document Thanks in advance
Hello please provide us the script if possible. One more request if u could bring some videos on performance testing when ETL migration happens. My team has asked me to get some metrics regarding this, if u could help me out.
It's very relatable to my project.Thanks for sharing this information.Keep posting such type of content.
thank you 🙏
You are shear very good knowledge keep it up mam....very useful for us
thank you 🙏
Nice explanation,..thank you..could you please make video on RCV and CDC process
such a relatable information, good teaching skill mam
thank u 🙏
Thank you so much for your Efforts to make this video
🙏🙏
Thanks a lot Sissy❤️❤️❤️...I commented u about this just 2 days back..n u posted it...hope I can learn many more from ur classes🙏🙏🙏🙏
🙏🙏✌🙂
maa'm very nice content ..thanks again🙏🙏
please continue session.
🙏✌✌
@@testerhoon28 ADF or ADB, please Ma'am iske upar bhi video bnye..
Apart from count,duplicate and column mapping what are the other things we will validate in the target table?
transformation logic, data validation, key validation etc..
Hi , an interviewer asked me "in your project at which stage SCD type 2 is implemented.
Whether its
SRC - Landing, OR
Landing to Staging OR
Staging to DW zone..?"
could you please help
from staging to dwh , scd type 2 implemented ..
@@testerhoon28 thank you very much.. :)
Very nice explanation..easy to understand 😊😊😊thank you can you please make automation vedio
thank you 🙏
Thanks for sharing ! helpful
Hi Mam,
Target par hone wale ye Full Load and Incremental load ke baare me ek confusion hai?
Jaise ki Target me Dimension and Fact Table hote hai? jab data incremental load me jata hai to vo dimension or fact table me kis tarah se load hote hai?
jo dimension table me SCD2 agar hota hai to kya vo incremental load ka hi part hai?
ek load hone ke baad incremental load he hota hai dwh me... chahe wo dim table to ya fact table..
muze 2nd point nh samja minus query wala - select col1, col2 from stage (source - stage )(stage-source) ye kaise minus krenge from source
First we can validate source minus target then we are validate target minus source
Please talk in English it's very useful to who are all not know Hindi
Di please add one more thing in next video what is performance tuning and how to optimize it 🙏
really superb
🙏
Thanks a lot very Best info
🙏🙏
Thank you Sister
🙏
Very useful video thankyou
Will you make a video on most useful Unix commands for ETL testing and how to see log files..
Thankyou in advance
To check log files i have already created one vdo long time back.. winscp... pls chk that... will make vdo on unix soon.. 🙏
Thank you for effort
Very well explained mam. I've one question.
Can we use "select * from stage_table" instead of select col1, col2, col3..... coln(uding all columns) from stage_table
The reason is, if we have almost 100 columns, we can't write all together right. So, could you please give clarity on this?
Thank you ❤
Yes you can use select * but for better understanding of data flow it's better to write each column name.
@testerhoon28 okay, thank you
How to become etl data warehouses tester
okay 🙏
good information
🙏
Please make video for target to DWH video. I am waiting. It's really helpful.Thank u.
okay 👍
please upload the videos in English..your videos and explanation was good and more informative and helpful...
okay 🙏
Please share how to do unit testing in SSIS
Complex se complex source sql query likhne ka tarika
Complex Target Query likhne ka tarika
Or dono complex Query ko kaise validate karte he ….Please Video bannayiye iss par
Sure 👍
Awesome
🙏
could u try to explain how to understand mapping document with real time examples, it would help me to more understand about the mapping document
Thanks in advance
okay 👍
Madam kindly make video on bug, how to follow up once it is raised.
ok👍
Just wowww
🙏
Could you please provide managerial round Questions
okay 👍🙏
Hi Please , prepare a vedio for Truncate & Load , Streaming, Incremental , Historical loads.
What are the different types of loads😅??
okay👍
Hello please provide us the script if possible.
One more request if u could bring some videos on performance testing when ETL migration happens.
My team has asked me to get some metrics regarding this, if u could help me out.
Hi, can you share frequently asked questions for 5 years experience
okay 🙏🙏
@@testerhoon28 Tomorrow I have very important interview, can you share some links or documents.Thanks!!
Pls make videos in english🙏 sis
okay 🙏
Hi Mam, Also pls upload videos in English.
okay 🙏