Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check the source record count from traget table.
- 5 Answers
- 14299 Views
- IBM, I also Faced
- E-Mail Answers
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 is staging area referring to?
what is the difference between cubes and package in cognos
what is Forward,Reverse and Re_engineering?
Explain the key challenges that you face while performing etl testing.
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
what is the difference between OLTP database and data warehousing database?
WHY CANT WE SEE THE DATA IN DATASET
what are business components in Informatica?
Difference between flat files and relational sources?
without using ETL tool can u prepare a Data warehousing and maintaining?
what are Lookup caches options? Including persistent caches.
what is the difference steps for data modeling?
Teradata 
