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
Explain about etl data integration software?
what is dynamic insert?
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 ?
What are cubes and olap cubes?
What are the differences between sql override and update override?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what are the concerns of OLTP and DSS systems?
What is Data Vault???
What is tracing level and what are the types?
explain the methodology of Data Warehousing?(Polaries)
Mention few test cases and explain them?
What is virtual Data Warehousing?
What is the difference between round-robin partitioning and hash partitioning?