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
- 4194 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 |
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 sql override?what is the use of it?
How can we store previous session logs?
How informatica recognizes mapping?
Diff b/w ShortCut and reusabel Object ?
Explain your project of banking domian.
How to use pmcmd utility command?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
how can we load starting with 11th record of a table from source to target
Have you worked with/created Parameter file
What are different types of transformations available in informatica?
what is the flat file partition and where have to specify it
Teradata 
