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
- 3619 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 are the transformations that are not supported in mapplet?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the informatica performance improvement tips
What are the different types of repositories created using informatica?
what are the deliverables?in your project?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain the difference between mapping parameter and mapping variable?
What is complex mapping?
What are the guidelines to be followed while using union transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is informatica? Why do we need it?
What are the new features of Power Center 5.0?
How do you update the records with or without using update strategy?
