How to Check the source record count from traget table.

Answer Posted / srinivas

write the source query in target table by using the schema
name.table name.
ex:
select count(*) from src.emp;

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain different types of partitioning?

779


What are materialized views & where do we use them?

695


what are the concerns of OLTP and DSS systems?

1724


explain the methodology of Data Warehousing?(Polaries)

1703


what are the types in error loging?

1839


What are the types of Data Warehouse applications?

715


Explain about the data integration suite features?

679


When do we go for the tools in the market?

732


How to fine tune mappings?

730


Explain what are the various etl tools in the market?

717


What is a materialized view log?

748


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

2806


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2034


What is the difference between Data Warehousing and Data Mining?

768


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

721