![]() |
| 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)? 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 : 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 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 Hi All,I need to put the value of a col (request-id) in the text of the body of the post-session success/failure email which I have to send in Informatica. How to achieve this? We cannot, I guess, use a Parameter File for this as it would take the same value everytime and put it in the email. I want to use the value of request-id which will be different on each session run and capture that value in some parameter/variable and use that in session in the post-session email.Kindly suggest a way to Read Answers (2) | Asked by : Tejasree Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq. Read Answers (1) | Asked by : mayur Latest Answer : you have to a string variable to input a date field, and while using it in mapping u need to convert it to date format . to_date(val,'format') ... Read Answers (1) | Asked by : Prajakta Borkar How to implement this situation:have one source and one target,while load into the target first delete then insert? Now I implement it through this way:create two source qualifier both for the same source,then config the target load plan to load into the target by order.but before I load into the target,I need to look-up Read Answers (2) | Asked by : Grayva
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||