2.ETL Architecture used in your project.
3.Can ETL Testing be used in all domains?(Healthcare and all?)
ANS:Yes
4.Which ETL tool used in your project?
5.How did you load the data from source till datawarehouse??
Using Control M Job scheduler tool
6.What kind of testing you do in your project?
Sistem integration testing-V-model
7.What are the testings you do?
Regression testing,Retesting,Adhoch testing,
8.Explain Defect lifecycle
9.How will you validate the data in ETL testing??Scenarios?
10.Write the query to get minimum,maximum,and avg of col2 of table A in a single query.
11.How will you validate duplicates?
12.What is the difference b/w Where and Having clause???
13.Difference b/w Truncate and Duplicate.Explain in detail
14.Left outer join,inner join and right outer join.
15.Where will you find the log files after job run ? how will you test log files?
16.How will you validate flat files.
17.List out the commands you know in unix
18.what is GREP in unix ?
19.What is PS ?
20.What is cd ?
21.How will you connect to Oracle SQL developer?
No comments:
Post a Comment