@@etlqalabs5048 sir ETL Testing perspective, how to write test cases before transformation and after transformation. And in which environment we have to execute?
@@deepakmamgain6949 i am not sure if you have watched other videos in the ETL Testing playlsit, I have covered the common test cases needed to execute in ETL Testing, if you need me to cover anything specific then please let me know , that too help thats the moto of this channel
Yes , you can use Joiner as well but keep in mind that Joiner has got all sorts of join types Inner join Master outer Detail outer Full outer However Lookup is only having left outer join which means if you cannot find the match , it will return null values which may be problematic if you have requirement to get only matched row, hope you got some ideas Also lookup is used in the middle of mapping whereas joiner is used normally from starting of mapping as source , also lookup can be performed on target table as well.
Hi sir, is this the role of the QA to create/design these things? I've seen your videos where you explained in the agile process testers are expected to do multi-tasking but what exactly are the roles and responsibilities of testing team members to handle? will there be an ETL developer to design these mappings? or do they expect testers to take part in this stage?
Agile team is a mix of developer and tester both so tester will be responsible for testing activities in real time project however the expectation is that you also know a bit of development so in case need you can support in ideal case
Hi Sir, very much thanks for ur session, but in our company, we are not provided any transformation logic or source target mapping sheet , How to do etl testing and prepare testcases sir ?
Having knowledge on any ETL tool gives you edge over development as well and your value increases significantly in the team and given we work in agile and cross functional is very nature of agile team so I would recommend you to learn any ETL tool not necessarily Informatica but since Informatica is widely used across industry so better to learn Informatica, having good knowledge of ETL TESTING with Linux and Database would be ok for you to get the job
Being an Etl tester myself, i never came across such a comprehensive channel till date. Kudos to your effort Sirji👏👏
More how to contact u , need suggestion about etl testing
Can u help me in etl testing
Thank you sir it means a lot ,I'm from NON-IT background, easy to track and understand
Informative session.. keep covering scenarios like this
Great effort sir, thank you
Please post these type of more realtime videos .It will be helpfull. Great work.
Thank you for making this video👍
It was good session
Great video .Great thanks for u r work and efforts.Thanks sir.
Love ur effort sir. It was great session. Thanks a lot. Sir one request to u make one video on how to write and execute tast cases. 🙏
Do you mean test case writting from ETL testing perspective or generic ?
@@etlqalabs5048 sir ETL Testing perspective, how to write test cases before transformation and after transformation. And in which environment we have to execute?
@@deepakmamgain6949 i am not sure if you have watched other videos in the ETL Testing playlsit, I have covered the common test cases needed to execute in ETL Testing, if you need me to cover anything specific then please let me know , that too help thats the moto of this channel
@@etlqalabs5048 sir I will watch ur playlist first. If anything needed I will let u know then. Thanks 🙏
Thank you so much Anna
Great job sir.
Please make some video on BI testing
can you pls include unit testing for unconnected lookup,scd's or when multiple transformations are involved at db level
Thanks for Uploading such a valuable content sir, I have query here instead of Lookup transformation we can use Joiner function for product know sir ?
Yes , you can use Joiner as well but keep in mind that Joiner has got all sorts of join types
Inner join
Master outer
Detail outer
Full outer
However Lookup is only having left outer join which means if you cannot find the match , it will return null values which may be problematic if you have requirement to get only matched row, hope you got some ideas
Also lookup is used in the middle of mapping whereas joiner is used normally from starting of mapping as source , also lookup can be performed on target table as well.
@@etlqalabs5048 thank you sir
Please make video on how to write query based on stm documents for testing perspective
Thank u sir
Very informative and useful sir. Can u make one video on role of ETL tester on Reporting with some scenarios/examples.
There is already a video on ETL testers role : do watch this
th-cam.com/video/rgFzXpNuRU8/w-d-xo.html
Hi sir, is this the role of the QA to create/design these things? I've seen your videos where you explained in the agile process testers are expected to do multi-tasking but what exactly are the roles and responsibilities of testing team members to handle? will there be an ETL developer to design these mappings? or do they expect testers to take part in this stage?
Agile team is a mix of developer and tester both so tester will be responsible for testing activities in real time project however the expectation is that you also know a bit of development so in case need you can support in ideal case
sir make 1 video for update strategy transformation and how it works in scd2. this is one of the most imp interview question.
hi sir
thanks for uploading ur videos
sir
can u do one video , how to tell introduction in interview for 4 to 5 years experience candidates
Sir, please let us know where can we find the excel sheet that you are showing in the video?
Hi Sir, very much thanks for ur session, but in our company, we are not provided any transformation logic or source target mapping sheet , How to do etl testing and prepare testcases sir ?
Sir can you pelase make video on same topic but for heterogeneous source systems
Hi sir,
Manual Etl Testing is having scope in the market.?
Since I don't have knowledge on informatica tool.
Having knowledge on any ETL tool gives you edge over development as well and your value increases significantly in the team and given we work in agile and cross functional is very nature of agile team so I would recommend you to learn any ETL tool not necessarily Informatica but since Informatica is widely used across industry so better to learn Informatica, having good knowledge of ETL TESTING with Linux and Database would be ok for you to get the job
@@etlqalabs5048 hello sir. I want Etl testing videos
@@gopalakrishna6114 please check the ETL testing playlist on this channel for that, do let me know if you need any other help
@@etlqalabs5048 once share me your contact details
Hello sir, where is the data loaded after transformed and run ? Where is the data finally loaded ?
Hi sir! can I get ETL testing topics?
Sure , suggest the topics , I am yet to catch on previous requests though
aggrigate???
Sir I want to meet you where is you're location bcz I have so many dought
Aaj paryant khup video pahile pan asa nahi bhatala kuthe ty sir