How to Check the source record count from traget table.
Answer Posted / nani
fire the query on target table.target table minus source table.
u can easily find how many records loaded.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what is a worklet?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What is a mapping?
what is data modeling?
What is a lookup table in etl?
Explain the difference between etl tool and olap tools?
Explain do we need an etl tool? When do we go for the tools in the market?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
Do we need an ETL tool? When do we go for the tools in the market?
What is full load & incremental or refresh load?
What is staging area referring to?
Explain etl mapping sheets?
Define Dynamic push down optmization?