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
- 3478 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 |
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
explain about informatica server architecture?
what is the difference between repository & Intergration service
what is polling?
Enlist the various types of transformations.
What is the difference between a table and the materialized view?
What is workflow manager?
What is meant by LDAP users?
How do you take back up of repository?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Teradata 
