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

when will use SQL override in a lookup transformation?

1879


how do u extract data from different data sources explain with an example?

1775


what is the difference between cubes and package in cognos

4526


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

553


what is the difference between cardinality and Nullability?

2509






what is the difference steps for data modeling?

1588


What is the difference between round-robin partitioning and hash partitioning?

547


How etl testing is different from database testing?

521


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1669


what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2162


what happens if the info.server doesn't find the session parameter in the parameter file?

1544


Do we need an ETL tool? When do we go for the tools in the market?

526


what are the reports developed in sap bw project and what is the requirement for developing it?

1774


What is cube grouping?

567


What is Data Vault???

2344