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 delete duplicate records by using filter transfermation?
which quality process u can approach in ur project
scenario
can any one explain me about junk dimension
what type of problem you faced insales project or insurance project
what are the limitations of pushdown optimization technique ? Advance thanks
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
what is datamart
What is a dimensional model?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?