How to Check the source record count from traget table.
Answers were Sorted based on User's Feedback
Answer / eswar
It's not possible to find count of source table records through target table if both databases are different.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / shyam
You can fire the query based on the timestamp.If the
loading happened today you can give the condition like--
>Sel * from table where date > 'yesterday's_date';
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
hi nani how can we fire query if the environment is
different i mean if my source is teradata and my target is
oracle
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / nani
fire the query on target table.target table minus source table.
u can easily find how many records loaded.
Is This Answer Correct ? | 0 Yes | 6 No |
What are your responsibilities as an etl tester?
what is the difference steps for data modeling?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
if i have a query as flat file how can we load data to target table
What is initial load and what is full load?
In Which Transformation We Can Use Having Clause In Informatica?
Mention few test cases and explain them?
what is session partitioning?
how do u implement unconn.stored proc. in a mapping?
Can u access a repository created in previous version of Informatica?
what is the meant by Normalization and de-normalization?
what is the difference between cubes and package in cognos