![]() 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 What is the impact of turning versioning on or off for an Informatica repository? What is the impact What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah Read Answers (2) | Asked by : Deborah In a Flat File source there r Null as well as Blank values .If u r doing the profiling for that source ,how do u gete counts for the Null and Blank separately instead of getting them as one countThanksManish View Question | Asked by : MAnish Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data. 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 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)? View Question | Asked by : lokendra Can anyone tell me how to create time dimension? Do we have to use type1,2,or3 for creating time dimension or we can just create it by using only expression transf and a date column from the source?Thanks in advance. Read Answers (3) | Asked by : monica
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||