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

How can we use mapping variables in informatica? Where do we use them?

837


What is a joiner transformation?

764


Explain informatica architecture - version 8 / 9

864


What is aggregate cache in aggregator transformation?

842


What all join we can perform in LOOKUP transformation?

756


What are the new features of Power Center 5.0?

1436


What is the difference between STOP and ABORT options in Workflow Monitor?

950


What is an expression transformation in informatica?

762


Can anyone tell me the new features in Informatica 9 Version?

1785


can we override a native sql query within informatica? Where do we do it?

869


Explain why we use partitioning the session in informatica?

806


Differences between version 7.x and 8.x.

1640


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1752


Performance tuning in UNIX for informatica mappings?

2339


Briefly describe lookup transformation?

794