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
What is the difference between round-robin partitioning and hash partitioning?
Can we create Hierarchies in generic datasources?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Can u access a repository created in previous version of Informatica?
Compare ETL & Manual development?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What are snapshots?
Do we need an ETL tool? When do we go for the tools in the market?
Explain me ETL project architecture in Detail?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the different Lookup methods used in Informatica?
What is a staging area? What is the purpose of a staging area?
when will use SQL override in a lookup transformation?
What is data cleaning?
State the differences between shortcut and reusable transformation