Interested to Buy Any Domain ? << Click Here >> for more details...
How to Check the source record count from traget table.
- 5 Answers
- 14277 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 |
how does the server recongnise the source and target databases.Elaborate on this
how do u really know that paging to disk is happening while u are using a lookup transform?
when will use SQL override in a lookup transformation?
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 is etl process? How many steps etl contains?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
Difference between flat files and relational sources?
Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the various tools used in etl?
how would u estimate the size of Lookup transform data and index cache?
Teradata 
