How to Check the source record count from traget table.
- 5 Answers
- 13086 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 tracing level? How many types of transformations supported by sorted input?
List few etl bugs?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
how many steps are there in etl process?
what are Lookup caches options? Including persistent caches.
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
what is pmrep command?
what is the difference between cubes and package in cognos
Two different admin users created for repository are________and_________.
what is granularity in Data ware House?
what is HISTOGRAM? how to generate statistics?
what is pmrep command?
Teradata 
