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


Please Help Members By Posting Answers For Below Questions

What are the three tiers in etl?

819


dimension object created in oracle can be imported in designer?how?

2707


how do u identify the changed records in operational data?

2335


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.

1617


What are the types of Data Warehouse applications?

748


What is staging area referring to?

839


What is partitioning? Explain different types of partitioning?

917


What are the modules in Power Mart?

753


how would u estimate the size of Aggregator transform data and index cache?

1760


Explain do we need an etl tool? When do we go for the tools in the market?

831


what is the difference between cardinality and Nullability?

2754


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?

2059


SCD2 will work on only dimension tables as well as fact Table?

1197


What are the key benefits of ETL Testing?

792


What are the various tools used in etl?

799