How to Check the source record count from traget table.
Answer Posted / shyam
You can fire the query based on the timestamp.If the
loading happened today you can give the condition like--
>Sel * from table where date > 'yesterday's_date';
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the three tiers in etl?
dimension object created in oracle can be imported in designer?how?
how do u identify the changed records in operational data?
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 are the types of Data Warehouse applications?
What is staging area referring to?
What is partitioning? Explain different types of partitioning?
What are the modules in Power Mart?
how would u estimate the size of Aggregator transform data and index cache?
Explain do we need an etl tool? When do we go for the tools in the market?
what is the difference between cardinality and Nullability?
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?
SCD2 will work on only dimension tables as well as fact Table?
What are the key benefits of ETL Testing?
What are the various tools used in etl?