Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4171 Views
- I also Faced
- E-Mail Answers
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
What is a filter transformation and why it is an active one?
Explain pushdown optimization and types in informatica
What is the difference between informatics 7x and 8x and what is latest version?
What is Index Caches size?
What does cheating measurement mean?
What are the different lookup cache(s)?
Explain the etl program with few examples.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the types of presistent cache in look up tr.
What is rank transform?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is intricate mapping?
What do you mean incremental aggregation?
How can we handle two sessions in informatica?
can u any challenge your project?
