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 |
What are Business Components in Informatica?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
How to list Top 10 salary, without using Rank Transmission?
Two Default User groups created in the repository are ____ and ______
What are the components of the workflow manager?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What are the types of data that passes between informatica server and stored procedure?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
i have 2 session s1 execute s2 load first session fail what is the reason?
how we do performence tuning in informatica