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
- 4091 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 |
What is union transformation in informatica?
how to load dimension table and fact table. plz tell me the steps.
when will we go for unconnected lookup transformation in Informatica?
Can we create a Integration service without a Repository service and vice versa?
How union transformation is used?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is target update override
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
What are the features of complex mapping?
Teradata 
