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
where to store informatica rejected data?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are mapplets?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to go to the older version for a mapping?
What are ETL Tools?
What is parallel processing in informatica?
How can you differentiate between powercenter and power map?
What is the Process to creating lookup transformation in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
Under what condition selecting sorted input in aggregator may fail the session?
Enlist the advantages of informatica.
What is fact table? Explain the different kinds of facts.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are mapplets? How is it different from a Reusable Transformation?