Mphasis ETL Testing Interview Question

[@SANJAYYADAV-hm2bs]

Thank you so much for the videos on ETL testing. Your contact are very very nice.

[@surajpatil3579]

Thanks mam.. keep making more content like this

[@Ganeshay-09]

Surrogate key A surrogate key is any column or set of columns that can be declared as the primary key instead of a “real” or natural key.The surrogate key is not derived from application data. It is the sequential number outside of the database that is made available to the user and the application or it acts as an object that is present in the database but is not visible to the user or application. We can say that , in case we do not have a natural primary key in a table, then we need to artificially create one in order to uniquely identify a row in the table , this key is called the surrogate key or synthetic primary key of the table.It turns out a surrogate key is very similar to a primary key in that it is a unique value for an object in a table. However, rather than being derived from actual data present in the table, it is a field generated by the object itself. A surrogate key is often a sequence number in a database such as a PostgreSQL serial column, Oracle sequence column, or MySQL auto_increment column

[@sandeepmedidi-v1d]

very helpful madam thanks for ur support.

[@testerhoon28]

🙏

[@ssiri-mk3lb]

Hi madam...U r videos are very helpful.... Please upload the client round interview questions... Thanks in advance

[@testerhoon28]

okay 👍

[@nilamnavgire2227]

teaching is best 👌👌can you send etl testing complete session🙏

[@testerhoon28]

for complete session you need to enroll in etl testing course ... 🙏

[@akashm1784]

U must have to cover all the questions in one video

[@RamchandraSangolkar]

continue this series ma'am

[@testerhoon28]

okay 👍

[@dattatraypatil2467]

I want real time project work on etl viedo

[@shrutimehra5230]

How much avg package can one expect in ETL testing profile ? 3-5 year exp ?

[@testerhoon28]

12-18L

[@shrutimehra5230]

@@testerhoon28 I have only ETL testing experience of 3 years. Manual and automation of ETL testing process. I don’t have any exp in selenium or any other tool. When I see opening I see selenium is mostly req with ETL testing also. Should I do any certification on it?

[@mubashiraf2524]

Please provide 12 th question answer mam,, or atleast which video u have covered that?

[@testerhoon28]

pls let me knw the question, i could not find out 12th question in the list...

[@mubashiraf2524]

@@testerhoon28 😅sorry I mean,, DB related 2nd question

[@Logical_Arunav]

Can you please share the document with us? It will really help me to prepare for a job interview!

[@testerhoon28]

okay 👍

[@y.c.breddy3153]

In ETL testing first which table date extract like dimension table or fact table

[@testerhoon28]

Both table data extraction happens at the same time ..

[@Kumar-w5q3v]

Hello Mam, thank you for posting the great videos. I have learned a lot about the ETL testing concepts from your videos. I want to switch my career to ETL testing. I have already attended some institute, which were sufficient to understand the theoretical and practical concepts to some extent. But I am struggling with real-life scenarios (e.g big data concepts, cloud etc) which may be asked in the interviews. I am looking for someone who can assist with some real-life scenarios. Can you assist with some one on one sessions? We can work on the fee structure etc. Please let me know if we can touch base via email or some other communication mode. I would be extremely grateful to you. Thank you in advance.

[@testerhoon28]

thank you for your kind words... pls email me @ [e-mail]

[@chinmayamahapatra-l1h]

Hi Mam can I connect with once I have some dowt in ETL I am lo good guidance who can guide a little please if have some time we can.

[@testerhoon28]

okay, email me at [e-mail]

[@sandeepkumarsingh4645]

Thank mam

[@testerhoon28]

🙏

[@priyakamble5746]

Please share any opening

[@amareshsn2605]

Please first give the definition for each question then explain it with examples. So we can understand properly

[@testerhoon28]

Okay 👍

[@prajakta887]

you said fact table has primary key then i can see fk in fact table

[@testerhoon28]

yes, primary keys of other tables... that a fk