Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check the source record count from traget table.
- 5 Answers
- 14224 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 |
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is a mapping?
when will use SQL override in a lookup transformation?
What is tracing level?
what is the difference between cubes and package in cognos
What is granularity? Please explain with example
what are the session parameters? How do u set them?
what are the parts of Informatica server ?
if i have a query as flat file how can we load data to target table
List few etl bugs?
Explain and compare etl & manual development?
what is the indicator file and where it is used?
Teradata 
