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
- 4103 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 |
Difference between task flow and linear task flow
Using Connected or unconnected lookup for performance wise which one is preferable?.
Could any one to tell Fact table Partitioning?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is the advantage of informatica?
how remove 1st 3 records & last 3 records in informatics
A session S_MAP1 is in Repository A. While running the session error message has displayed
Explain about perform recovery?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Why we use lookup transformations?
Teradata 
