How can one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?
- 1 Answers
- 4307 Views
- I also Faced
- E-Mail Answers
Answer / hari
to look at the explain plan of the sql query which is issue
to database from infomatica.
have a look at the user_indexes with
table_name=<<TABLENMAE>>
have a look at user_tab_partition where
table_name=<<TABLE_NAME>>
TABLENAME, which are used in the informatica sql query...
| Is This Answer Correct ? | 1 Yes | 1 No |
Performance tuning( what you did in performance tuning)
What is domain in terms of informatica?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
When the informatica server marks that a batch is failed?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
How/where can i install Informatica software with oracle or teradata as database
how can we use sorter transformation in joins?
What are ETL Tools?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What is a code page?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
Teradata 
