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 initial load and what is full load?
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.
State the differences between shortcut and reusable transformation
what is data modeling?
What are the ETL Testing Operations?
flat filevalidation in informatica
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.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is partitioning? Explain different types of partitioning?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is a worklet?
what is an ETL or ETT? And what are the different types?
What are cubes and olap cubes?
what happens if the info.server doesn't find the session parameter in the parameter file?
What is Data Vault???