How can one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Partition, what happens if the specified key range is shorter and longer

2240


Explain what are the different versions of informatica?

885


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2090


What is meant by lookup transformation?

815


What is a sorter transformation?

899


Mention some types of transformation?

814


Define filter transformation?

883


According to his methodology what all you need before you build a datawarehouse

1451


What is dimensional table?

825


How to implement security measures using repository manager?

857


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3820


Explain the aggregator transformation?

868


Explain the shared cache and re-cache?

844


lookup transformation with screenshots

3783


How you prepared reports for OLAP?

1371