 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 ... What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys? Read Answers (5) | Asked by : kishore I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks, Read Answers (1) | Asked by : Adi Tags : Metadata 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 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 (2) | Asked by : mayur I have a datatype as varchar2 in source table and when I load the data in the target table it is mapped to nclob datatype.when I run the mapping , there are junk values in my target table which has nclob datatype.Could you please let me know how to solve the issue.Thanks in advance View Question | Asked by : radha krishna I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana Read Answers (6) | Asked by : nayana
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
