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
How can we use mapping variables in informatica? Where do we use them?
What is a joiner transformation?
Explain informatica architecture - version 8 / 9
What is aggregate cache in aggregator transformation?
What all join we can perform in LOOKUP transformation?
What are the new features of Power Center 5.0?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is an expression transformation in informatica?
Can anyone tell me the new features in Informatica 9 Version?
can we override a native sql query within informatica? Where do we do it?
Explain why we use partitioning the session in informatica?
Differences between version 7.x and 8.x.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Performance tuning in UNIX for informatica mappings?
Briefly describe lookup transformation?