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
- 4089 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How we can create indexes after completing the load process?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the modules in Power Center
What is the way to execute pl/sql script using informatica mapping?
What is persistent lookup cache?
What is the use of code page?
How can we use mapping variables in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
what is the size of your data warehousing?
How to generate sequence numbers without using the sequence generator transformation?
Slowly changing dimensions, types and where will you use them
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to update a particular record in target with out running whole workflow?
How to start a workflow using pmcmd command?
