|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)? Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ... Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita. Read Answers (3) | Asked by : Arpita Latest Answer : In Session properties SELECT treat source rows as UPDATE
In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ... Latest Answer : CREATE OR REPLACE PROCEDURE TIMEDIMBUILD (p_start_date IN DATE, p_end_date IN DATE)AS v_full_date DATE; v_day_of_month NUMBER; v_day_of_year NUMBER; v_day_full_name VARCHAR2(30); v_week_number ... Can any body tell me the configuration of informatica in UNIX, or if it is lenghty pls send the doc. Can any body tell me the configuration of informatica in UNIX, or if it is lenghty pls send the doc. thanks in advance When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a \n character. Read Answers (1) | Asked by : raj You can download an IBM Book on Dimensional Modeling from the following link:http://www.redbooks.ibm.com/abstracts/sg247138.html?OpenThis is an excellent IBM Redbook on Data warehouse design and Dimensional Latest Answer : Guys,http://freedatawarehouse.com/tutorials/default.aspxCheers,Sithusithusithu@hotmil.com ... Hi all,I am getting the following message when I start theinfa Repository server ..Could not start INFORMATICA Repository SERVER on Local ComputerERROR 1053 : the service did not respond to the start or control request in a timely fashionThis is the first time I found the above problem.Could you plz let me know what might be the reason ..Environment : Win sever 2003 , Oracle 9i and Infa 7.1.1.Thanks in Advance ..Thanks,Priya Read Answers (2) | Asked by : priya... In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens? Read Answers (8) | Asked by : reddy
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
