ETL Testing 5 hours complete training | ETL Testing interview preparation | What is ETL testing
ฝัง
- เผยแพร่เมื่อ 20 ธ.ค. 2024
- #etltesting
In this video we will learn
etl testing interview questions and answers,
etl testing interview,
etl testing real time,
ETL Testing: What, Why, and How to Get Started
ETL Testing,
Basics of ETL Testing with sample queries,
ETL testing interview preparation,
Introduction to ETL Testing,
ETL Testing Tutorial for Beginners
========================================================
Informatica Self-Paced Courses and Interview Questions Links:
courses.nicita...
Are you interested in joining my Live training? or Self-Paced course?
Feel free to contact me for more details @+917010080468 🌕 wa.link/m4lat0
WhatsApp group:
chat.whatsapp....
Please visit our website for more details.
www.nicitacade...
Thanks,
NiC IT Academy
========================================================
📌 Please write to me for any help on ETL testing - nicitacademy@gmail.com
Please add your suggestions/feedback/Queries in comments, I will answer it and I am happy to help you
📌 Like the video and forward it to your friends circle.
📌 Informatica training in TAMIL - Playlist
• Informatica Training -...
📌 Informatica training in ENGLISH - Playlist
• Informatica Training S...
📌 Informatica Interview Preparation - TAMIL
• Informatica Interview ...
📌 Informatica Interview Preparation - ENGLISH
• Informatica Interview ...
********************************************************************************
Informatica Self-Paced Courses and Interview Questions Links:
courses.nicita...
Are you interested in joining my Live training? or Self-Paced course?
Feel free to contact me for more details @+917010080468 🌕 wa.link/m4lat0
WhatsApp group:
chat.whatsapp....
Please visit our website for more details.
www.nicitacade...
Thanks,
NiC IT Academy
*********************************************************************************
📌 Oracle SQL - Complete tutorial Playlist
• Oracle SQL Tutorial - ...
***********************************************************************************
📌 Oracle SQL Day wise Video:
Oracle SQL Tutorial - Day 1 - • Oracle SQL Day 1|Oracl...
Oracle SQL Tutorial - Day 2 - • Day 2 - Oracle SQL for...
Oracle SQL Tutorial - Day 3 - • Day 3 - Oracle SQL for...
Oracle SQL Tutorial - Day 4 - • Day 4 - Oracle SQL for...
Oracle SQL Tutorial - Day 5 - • Day 5 - Oracle SQL for...
📌 Oracle Day 3 Notes:
=====================
drive.google.c...
**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
• Master SQL in 6 Hours ...
📌Oracle SQL Day wise Video: TAMIL
-----------------------------------
Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
Oracle SQL in Tamil Day 9 - • Oracle SQL Analytical ...
Oracle SQL in Tamil Day 10 - • Views in Oracle SQL TA...
************************************************************************************
🔥 • Informatica Training S...
• Informatica Interview ...
In this video, we’ll learn what is ETL testing
ETL testing Interview preparation
ETL Testing
etl v/s database testing,
etl training,etl tutorial,
data cleansing,
etl training course,
data warehousing,
etl tutorial for beginners,
etl,etl v/s bi tools,
staging area,
dimensional modelling,
scd types, dimension tables,
fact table, normalization, dimension table,
enterprise ware house schema,
star schema, snow flake star schema,
architecture of data ware houses
====================================================
Audio track credit:
Believe Music
🌐 *Register IICS/IDMC/Cloud - Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
🌐 *Are you interested in joining my Live training? or Self-Paced course?*
www.nicitacademy.com/
✅ *WhatsApp Group for Informatica technical discussion*
chat.whatsapp.com/JXCF1i06BCS64JqE0L209r
☎Contact us for more details
WhatsApp: @+91-7010080468 🌕 wa.link/m4lat0
Direct call & WhatsApp: +91-99529 74013
*Oracle SQL Playlist*
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
*Informatica PowerCenter Playlist*
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
*Informatica IICS Playlist*
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
*Oracle PLSQL Playlist*
th-cam.com/play/PLsphD3EpR7F_mXwcliOLEmnNUB7ZpxGdB.html
*Microsoft Azure Playlist*
th-cam.com/play/PLsphD3EpR7F8_sOED5d2oS6cIpCwOBjMV.html
*Oracle SQL - தமிழில்*
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
*Informatica PowerCenter - தமிழில்*
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html&si=pxEnhkIPT3IkQ-R9
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
Thanks,
NiC IT Academy
Simply wow, explained every well, even nill knowledge person also will understand in first attempt
Thank You very much. Keep watching my channel.
This is the best ETL testing video I have ever seen...covers all concepts from Start to the End... great session 🙌👏
Wow, thanks! Keep watching my channel.
Thank you soo much sir for your valuable video which was explained in a very good way where a zero knowledge person can get self confidence to attend interview for etl testing.
Thanks and welcome
I can easily understand SQL when you explain in tamil
Complete agree its a wonder session which cover all the area of ETL testing. Thank you so much!!
You're very welcome!
That's the video I was looking for. Thanks!
Thanks, Keep watching my channel.
Sir is enough for informatics.... Thanks for this video
Most welcome, yeah its enough
Iam a ETL developer . Video is so usefull.. expecting more videos for etl and future development in ETL
Thanks, Sure
Hello Hai bro I'm learning Sql course present how it's jobs and working bro please reply me
Hai Bro, i have some doubts about ETL , can i make a call to you bro
tq sir these classes use full in medille class pepules
You're most welcome
Thank you very much 🥰 for uploading video full course
Most welcome
Your session is very good and informative 🙏🏻
So nice of you. Thank you! Keep watching my channel.
Love the way you are explaining, thanks a lot
Thanks for liking. keep watching my channel.
Sir super teaching... God bless you...
Thank You, Keep watching my channel.
All rounder performance 👍👍👍👍
Nice video 🎉🎉🎉
Many many thanks. Keep watching.
Most expected video...keep rocking
Thank you so much 😀
You are the best Sir!!!
Thank You. Keep watching my channel.
courses.nicitacademy.com/courses
I love the way u teach👌👌
Thank You, keep watching my channel. Post your queries in comments.
sir you're doing great job
Thanks and welcome
Wow, it's great explanation. Please upload teradata sql and ETL real time project also...
I have already posted Teradata videos in NIC IT Academy 2.0
Please check th-cam.com/video/oj-6c4ybuSU/w-d-xo.html
Very well and beautifully explained Sir.. 🙏🙏🙏🙏🙏 Thank you..
Thanks 🙏. Keep watching my channel
Overview of testing - Diagram 21:32
Superb video sir..
Thanks a ton. Keep watching my channel. Add your queries, I will create new video on the required topics.
Thank you For this Video.
You're welcome
Thank you so much. Wonderful subject. The ways u have explained terrific . Could you pls share some real time live project. For validation
Thanks for your wonderful feedback. Keep watching my channel.
Excellent!! This is the best video I ever seen in TH-cam😍
Thank you so much 😀
Great sir. Its very useful
So nice of you. Keep watching my channel and support.
Very helpful..Thankyou👍
Welcome 😊 Thank You!. Keep watching my channel.
its verry useful sir...keep rocking...
Thank you, Keep watching.
Thanks for the videos that you have shared with us
Savior
Thanks Brother. Keep watching my channel
i wish this video has english sub, that's so great 🥰
Working on it!
@@NICITACADEMY .
Sir, please make a vedio for ab initio tool either in dev or testing, it will be more helpful
it is really helpful except the ma'am asking too many question as dev side.
Thanks
Keep rocking....sir
Thank you.
Sir I want to know if informatica still holds its values in 2022? There are other tools like Talend what do you think which etl tool is best for career growth.
Send some interview questions or how to crcak interview tricks
Great explanation sir
Please make one video on how to create and why do create or who create traceability matrix documents as etl tester
Sure. I ll do.
Keep watching my channel
@@NICITACADEMY sure
Please sir u explain tamil video also in etl testing process
Sure
Waiting for tamil
Hi Sir, Thanks for your tutorial.
Can you please post this tutorial in Tamil.
Thanks, Will upload soon. Keep watching my channel.
Super explanation
Thank you 🙂
It's really very helpful for us. Thank you so much brother, the way of explanation is very good and if possible could you please share some Realtime live project validations in ETL testing.
Sure, I will share it. I have already discussed some of the Realtime use case. please watch it second half part..
Please do more videos on ETL testing sir
Sure, I ll do.
hai sir good morning i have join etl testing.
Ok good. 🌕For more details contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
Hi Sir, This tutorial was very useful. One small request from can you also please post the same ETL tutorial in tamil.
It is already available
th-cam.com/video/8p35ZXnhvxk/w-d-xo.html
@@NICITACADEMY Thanks sir
Could you upload tamil version 🙏🙏
Hi bro,
This etl testing is only for testing domain right?
great sir
Thanks
Sir I need urgent video on hpalm or notes prepared by u
source have 10k records without any transformation applied data moved to target directly
what are the validation tester perform ??
Since it is one to one load, We can do below testing
1. Count check
2. Null value check
3. Data type and data precision check
4. Target-Source and Source-Target
etc...
4th one is Minus query??
A-B and B -A ?
GREAT!!!😀
Hi Sir, could you please share me the link of sql which you were mentioning, i could only see oracle sql in your playlist
th-cam.com/video/yukL9vRalVo/w-d-xo.html
Great 👍🏻
Thanks ✌️
Nesecito subtítulos en español o en ingles!! Gracias!!
Thanks so much
You're welcome!
How to check data consistency and How to check if table has ASCCI values..I am not able to answer...plas give the answer for those questions
Nenga tamil? I have 7 years in manual testing. I planning to move to ETL testing domain. I need some guidance from you. Can you please help me
Please watch my ETL testing full session, ETL developer full session. We have lot of openings
Sir, Are you providing online training.
Sir .I need ETL testing live project please upload it ..I need it for my prepration
Hi can you please share all the materials that you used during 5 hrs session? including TCs, STTM etc?? I would be greatful
Please check here
courses.nicitacademy.com/
Informatica ETL TOOL VS Talend Etl tool wich one is best tool please suggest me sir
Informatica PowerCenter is widely used ETL tool.
Thanks for reply sir when will you start new batch sir
Very useful content, My primary skill is different but I got an opportunity on ETL Testing by learning this video. Thankyou so much sir. Is there any full ETL Testing video sir?
I will add more videos on ETL testing. Keep watching my channel.
Sir pls Talend ETL tool using Oracle SQL tutorial vedio post pannugka sir
With English subtitle
best video
Sir please provide some pdf s related to this...
Could you please Upload Tamil version of ETL testing🙏
📌Please visit our website for interview questions
nicitacademy.com/
📞For more details contact me on WhatsApp (+91 7010080468) or the below link
wa.link/m4lat0
📞 Direct call & WhatsApp @ +91-99529 74013 🌕 wa.link/8szdvc
Sir is there sql vedios also you did..
🔵Oracle SQL Tutorial - English
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
As yo mentioned for dimension table, there would be only Non-measurable data. In product dim table there is price of the product, isn't it measurable.? Thank you
Sir any video on only hpalm
I will upload soon. Keep watching my channel.
Thank you sir !!
Most welcome!
how much ETL tester has a scope in career ? and what should be the next step after ETL Tester?
Hi, ETL tester has good scope and you can move on to Big data testing, Data lake testing further. So be confident and learn it. SQL and Unix is mandatory
Hello sir, your videos are useful for etl Testing aspirants, Could please share the file and how to install hp QC in pc
Hi Chandra sir, it seems You are like Etl dictionary. Do you put any videos related tableau report testing
Thank you for your wonderful feedback.
I will add Tableau video as well. Keep watching my channel.
Hello sir, if source is flat file and target is database then how we can validate data from staging to data warehouse?
We have use some tool to test it like Querysurge.
@@NICITACADEMY can you make video on this topic?
Hii sir
If source have 100 records and target gets 80 records only. How to get back those records in to target using in informatica
Check my TH-cam session on debugger and dependency check.
Can you send video on jira and hpalm
Yes, I will upload soon.
@@NICITACADEMY thank you very much sir... really I learnt too much from ur video
hi sir how can we test if sourceid of one DB type as oracle and target is Teradata kind of thing? can you please make one video for better understanding in that scenario?
I have explained the same scenario in this video itself. Please watch without skipping.
@@NICITACADEMY We need to load the data from in to staging by creating Teradata connection which makes the data will be stored in Teradata . Can you please let me know my understanding correct or not? I am little confused here so just wanted to have clarification.
yes correct, That's the way we can test it,
Approach 1: Create a stage layer in TD and do one to one load in TD and compare TD stage to TD target.
Approach 2: otherwise we can go with some tools like QuerySurge to compare data from two different data bases.
Got it sir thank you Appreciate your efforts in providing the knowledge on informatica sessions
@@NICITACADEMY Sir I could not find video on joiner transformation? Can you please upload the same?
I joined as Etl tester with Sql knowledge but I don’t know how to do any validations in Etl but they took me based on my Sql. Can you please help me out how to work on this as I’m from mapping background and I changed my domain recently. So it’s being very tough for me to work on.
please watch my SQL Session.
Hai , i have some doubts about ETL, i think u already worked on it so can u help me
Hi r u a etl tester....I have one doubt
Could you please make ETl testing in Tamil
Sure I will do
Sir I have completed mechanical engineering 2018-19 batch, i got gap i dint worked anywhere, now I want to join it sector, some people recommending me to do ETL TESTER COURSE, what's your suggestion, plz reply
Yes definitely you can learn SQL and ETL testing and you can try for IT. More of our followers getting job. so prepare and try.
@@NICITACADEMY sir in etl testing work pressure is more or normal? Does we get wrok from home work in etl testing or not?
It is based on the project where we are working.
The whole video is for the ETL tester role or etl developer role.?
ETL Tester role
All good..But the time, live lesson starts, there is one girl keeps asking repeated questions with lots of attitude..Which is irritating..
Please send me interview question a nd answers for etl testing in pdf..
Hi sir etl admin and etl tester both are same?
No, both are different. ETL admin who manages Informatica Server. ETL Tester will do testing on ETL developer's code.
So which is best among these etl admin vs etl devoloper vs etl tester?
All 3 is best only, Choose any one and have in-depth knowledge. ETL developer will have more demand compared to ETL admin.
Is it enough for IBM data stage etl tool
Yes, it is enough, Just learn what is Informatica.. basic concepts. because Informatica is widely used ETL tool in many projects.
Sir please send me manual pdf for simple project.. So everybody easily understand it.. Actually I am having zero knowledge and trying to get job with ur vlogs only
@@bojanapureddemma5840 Someone will ask to upload in Turkish
Hi sir, I have couple of things to clarify..... Please get time to help me out....
Thanks...
I am into Manual Testing now. Having basic knowledge in Selenium-Java and Database testing. I am planning to upskill myself on ETL testing.
This would be really helpful.
Couple of doubts I am having before starting it.
1. Is this course enough for starting a career in ETL testing??
2.What are the pre-requisites??
3. Are you providing any online courses??
Is this completely enough for etl testing any topics missing or do we need to learn more. .
Please SQL session and this ETL testing session, it is more than enough to crack interview.
Sir ..is there any jobs right now for etl testing,.and can you please help us to make naukri profile skills...what about future Career in etl????
hi, Lot of job opportunities are there for ETL tester.
@@NICITACADEMY sir ..i m not getting calls from naukri ...what should I do?? I hv completed course in January...
Talend ETL developer video can u do like this ?
Yeah, I will do, Keep watching my channel.
@@NICITACADEMY ETL developer role video available ?
Hii sir which course is best for non it graduates with work from home job for future demand jobs
We can't say which is best, everything is best. but we need to have complete knowledge on this. ETL is best tool and have complete knowledge, we can say many tools and cloud systems as well.
@@NICITACADEMY thank you
With English subtitles for talend ETL tool pls
It will be very helpful if can give online training for ETL testing
Yes, definitely
Sir .i need ETL testing live project if any course available
Will upload soon
What was fee for ETL testing course , how can I join
please contact me nicitacademy@gmail.com
Sir, is this enough for 3 plus experience knowledge in etl testing?
Yes, it is more than enough.
@@NICITACADEMY for practical? Sir
May I know the migration project duration ?
Its depends
It's depends okay I understand but minimum duration? If u know let me know
when we prepare test cases, we are only preparing test cases that are mentioned on (STTM) mapping document right? or do we need to prepare other test cases that are not in the STTM? for example nulls validation and other validations? this one has always confused me.
Sir do we need programming languagus to learn informatica
No need of programming, only SQL knowledge is enough.
TQ sir
Thanku sir
Hi dude
Using Informatica, flat file data can be loaded into staging, and developers can add any logic.
Or, the mapping will be tested.
Hello Sir I want to learn the entire etl developer,ideally I'm from commerce background could you please help me
Hi, I have posted entire developer training video in our channel, please start learning it.
@@NICITACADEMY hello sir hood morning tq for reply I tried alot to check sir couldn't find it could you please help me the link over here the entire playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html