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
- 4191 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 |
How to create Target definition for flat files?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
how can import the data from the flat files?
what is data driven?
What is informatica etl tool?
How would you copy the content of one repository to another repository?
What is the difference between view and materialised view?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What did you do in source pre load stored procedure
Teradata 
