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
- 4104 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 designer tools for creating transformations?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the sql query overwrite in source qualifier in informatica
What are the measure objects?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you load alternate records into different tables through mapping flow?
What is a repository manager?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain sessions. Explain how batches are used to combine executions?
Explain the difference between a data warehouse and a data mart?
Explain the tuning lookup transformation - informatica
Explain the different dimensions.
How are indexes created after completing the load process?
What is the difference between source qualifier transformations source filter to filter transformation?
design of staging area?
