ETL Testing Interview Question Part-2
ETL Testing Interview Question Part-2
14. How to display duplicate records
15. Difference between Drop, Delete, Truncate
16. Do you know about informatica?
17. What is Mapplet?
18. What is Workflow?
19. What is Session?
20. Do you know about the informatica Scheduler?
21. Test Management tool
22. Defect Life Cycle
23. NVL and NVL 2 Explain
24. How to display 4th and 7th records from the table
25. Positive and Negative Testing Scenarios
26. Suppose Source table having 1000 records but in target loaded only 800 records then How you Validate the Data
27. From Source to Staging how you are getting the Data
28. Can You tell some table names in your staging area?
29. Suppose we have 100 records in source, we have to do one to one mapping but in the staging, datatype is different other than that everything is same. Explain How you validate the data.?
30. Can you Explain what validations you have done in your project.
31. What are the Constraints you validated?
32. EMP Table
Emp_ID Emp_Name Manager_ID
Write A Query to Fetch the Employees who don’t have any managers.
Departments Table
Dept_id Dept_name Emp_name
2. Write a Query to fetch all the records from the Emp and Matching records from the department table
Пікірлер: 22
thank you
Thanks for uploading
@testerhoon28
Жыл бұрын
🙏🙏
Voice is not clear during making this video....so plz focus on reduce eco of sound
@testerhoon28
Жыл бұрын
okay , thanks for the feedback... 👍
@saiprasad questions A left join B and right join C out put of records counts will be 6000
Please explain in a video about developer environment and qa environment. And what challenges faced in qa environment
@testerhoon28
Жыл бұрын
okay 👍
@stormhawk23
Жыл бұрын
@@testerhoon28 thank you
Hi mam, Where I can share my etl interview questions
@testerhoon28
Жыл бұрын
email me @ tmadamji@gmail.com
are you from Bhopal?
@testerhoon28
9 ай бұрын
no
your video sound quality is not good, after keeping 100 % also it is not clear , pls check and thanks
@testerhoon28
Жыл бұрын
yes I know in my old vdo sound quality is not good... m trying to improve the sound quality.. thanks for letting me know 🙏
your voice is not cleared when given the answer of validation part.
@testerhoon28
23 күн бұрын
Okay will improve the voice quality 👍
answer of 26th ques. is still not clear :| .. For that maybe we can use source qualifier.
@testerhoon28
Жыл бұрын
to validate data we have to use sql queries... source minus/except target and target minus/except source... i hope its clear now
@kartikjuneja7807
Жыл бұрын
Sorry for 29th I was asking.
@testerhoon28
Жыл бұрын
@@kartikjuneja7807 in 29th question again we have to validate the data.. not the data type.. for that we have to take all the possible combinations of data.. tosee how data is loading in different datatype...also in different tool we dont have that much facilites to chk data using tool... better to check data using sql🙏
@nsps8858
Жыл бұрын
Hi mam can you explain how to validate data from source to target if data base is different of both?