How can one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?
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 update source definition?
Explain the aggregator transformation?
How informatica process data means how informatica works?
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?
Explian the Process of deployment groups in informatica
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What is the benefit of session partitioning?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
What do you understand by term role-playing dimension?
Explain scd type 3 through mapping.
what is fact and what types of fact tables is there