![]() 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 : We can update the target table, by using the update override in target definition. it will update based on non key columns. ... 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 ... Suppose one flat file taking loading time of 3 hrs.How u can reduce that loading time to 1 hr.( No FTP, Not UNIX system to make parallel processing,No splitting file,and all servers and files and targets existing in same system) Read Answers (3) | Asked by : Jagadeesh 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 (9) | Asked by : reddy Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data. Hi all,Could anyone tell me why session fails when running a workflow? I don't see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.ThanksKamalnayan Read Answers (4) | Asked by : Kamalnayan Maramraj Tags : RDBMS
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||