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

What is initial load and what is full load?

709


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.

1611


State the differences between shortcut and reusable transformation

766


what is data modeling?

2087


What are the ETL Testing Operations?

835


flat filevalidation in informatica

1938


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1767


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

884


What is partitioning? Explain different types of partitioning?

895


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1754


what is a worklet?

771


what is an ETL or ETT? And what are the different types?

7218


What are cubes and olap cubes?

766


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

1741


What is Data Vault???

2536