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
- 3620 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 |
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
Enlist the differences between database and data warehouse.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are events in workflow manager?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
WHAT IS FACT TABLES?
How we can create indexes after completing the load process?
explan ur project architecture?
Is it possible to update the target table with PK?
why we are using level option in normalizer transformation
What is the Difference between sorter and aggregator?
Teradata 
