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
- 3810 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 |
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
What is update strategy transform?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
How many types of sessions are there in informatica.please explain them?
What is meant by lookup transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what is song in infrmatica...?
Write the program through which the records can be updated?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What is the way to execute pl/sql script using informatica mapping?
Teradata 
