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
Partition, what happens if the specified key range is shorter and longer
Explain what are the different versions of informatica?
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.
What is meant by lookup transformation?
What is a sorter transformation?
Mention some types of transformation?
Define filter transformation?
According to his methodology what all you need before you build a datawarehouse
What is dimensional table?
How to implement security measures using repository manager?
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
Explain the aggregator transformation?
Explain the shared cache and re-cache?
lookup transformation with screenshots
How you prepared reports for OLAP?