ETL Testing | Incremental Load in Informatica( ETL) with RDBMS source| Full load vs Incremental load

[@surajpatil3579]

I appreciate your hard work sir 🙏 Thanks again for solving doubts... keep making content like this..

[@soujanyamirje4708]

Hi sir, Today only I seen your vdo's and planned to do study today only ,now I started my preparation on ETL , i want to do job as ETL software tester ,sir really you are doing very good job , I really very thankful to you sir . after watching your vdo's i got a lot of confidence i'll challange myself as ''yes i'll deffinately get a job in next month only''(june).

[@etlqalabs5048]

You will definitely get into good company. Just follow the playlist to learn the following order 1. SQL 2. Linux 3. ETL testing 4. Software testing 5. Data warehousing 6. Python ( optional if you are fresher or junior )

[@soujanyamirje4708]

@@etlqalabs5048 Yes sir ,Thank you so much sir...

[@soujanyamirje4708]

@@etlqalabs5048 Hi sir, i have one doubt without using count how to find how many records in the table.?

[@sdetkrishan]

Thank you so much sir for sharing valuable details on incremental load .

[@prasannachowdhary358]

Sir..its really awesome job. We are learning each and every concept through your videos. Thank You Sir. Thank you so much But sir 1 request from my end Could you show etl testing process from stating phase ODS to ending phase BI Reports including how to load data and all validations in 1 complete video please.. It will help us lot sir...

[@manojkumarhk5696]

How do we test SCD type 2 with Incremental load?

[@etlqalabs5048]

Please do explore the videos on slowly changing dimension in data warehousing concept and information section. I am sure it's covered somewhere

[@NeuUniversity]

hello Sir, how this Incremental load works in the target? because in the Target There are 2 types of table Fact and Dimension table? for dimension Table - Can we consider that SCD type 2 is a part of incremental load?

[@etlqalabs5048]

Scd types applies to dimension tables only. Incremental load is different where we only load update/ new rows from source and reject the rows which have no change between source and target. Hope this helps . Do let me know if you have any other questions

[@rajanii2494]

VERY NICE EXPLANATION

[@sonurawat7069]

do we need to change mapping variable default value at each incremental load? because 1st time it is- '01-01-2021' then 2nd time max doj is '21-01-2021'

[@dhirajgupta1321]

I have created workflow in workflow manager but doesn't display in monitor plz tell what is the reason behind it?

[@mangeshmehare9669]

Nice explained

[@amitchorge9697]

@ETL QA Labs...But,sir what if there is no any DATE coloumns in Source table then?how to validate test cases for incremental load?

[@avinashkamble8812]

Sir plz do one video of all important questions on etl testing

[@nidhisingh4973]

Hello Sir, Thank you for this video. Can you please clarify my below doubts. 1)how the record will be updated in target table if there is change in existing record details in source table. 2) How to get/maintain last inserted value in target if there is no DATE column in Source table

[@PraveenKumar-il8kn]

Hi Sir, Video is very informative are you providing any trainings related to ETL testing.

[@praveenshahapure5556]

Hello Sir, Thanks For Sharing your knowledge with us, I'm requesting you to make video indirect file load method with 10-20 files ,

[@manjunathaml8649]

sir i have 10 years data(huge not acceptable in excel) in my db2 and i want to migrate it to oracle database can you explain the data migration along with this example, it could be helpful tq

[@etlqalabs5048]

Dear Manjunatha ! This is good question however it looks more of a open ended question. I assume this is just a migration project which involves some level of transformation - let me try to explain what needs to be done from development and testing perspective - *development perspective :* 1) Migration of all ETL jobs (which are feeding to db2 ) to Oracle as a target systems b) Existing 10 years data also need to be migrated from db2 to Oracle *2) QA/Testing perspective -* a) Certify all the ETL jobs post migration to Oracle and ensure they work exactly in the way they were working before - All ETL testing needs to be performed - i) Compare ETL jobs with db2 vs Oracle in terms of job behaviour ii) Check the database objects between db2 and oracle and they should also match like indexes, keys, constraints , data modelling etc.. iii) Compare the data between db2 and oracle b) Historical data testing post migration should match between db2 and oracle These are some of the activities from development and testing perspective. I would also recommend you to watch ETL Testing playlist for better understanding of testing from ETL standpoint. Hope this clarifies and give you some insights.

[@manjunathaml8649]

@@etlqalabs5048 ya now i got some clarity on that, thank you sir

[@jai7104]

thank sir

[@manikantaakula3751]

Can plz explain the production issue

[@125vikas1agrawal]

Sir can you plz explain how to validate data between putty to staging area. Because the database are different of both system. Plz sir🙏

[@Visionpro33]

Sir please make a video on how to write test cases ,