insert date in oracle
columns in oracle source table is of type and size as follows:column_a date 19column_c date 19In informatica expression transform, this what I have:column_a date/time 29column_c date/time 29I need to insert the records into sql server 2008 with different column size. column_a datetime 23column_c datetime 23Column_a and column_c is inserted into sql server target table. But in informatica session logs error. I am not sure what the problem.database errors occured:FnName: Execute -- [DataDirect] [ODBC SQL Server Driver] Fractional TruncationERROR: Writer Execution FailedThis only happens when column_c is linked to the target table. When I remove column_c link in the target, with just column_a. No errors.Has anyone worked with oracle date from source to sql server date target?
Just released is the latest version of the market leading document security technology from Oracle. Oracle IRM 11g is the result of over 12 years of development and innovation to allow customers to provide persistent security to their most confidential documents and emails. This latest release continues our refinement of the technology and features the following;
- Continued improvements to the web based Oracle IRM Management Website
- New features in the out of the box classification model
- New Java APIs improving application integration support
- Support for DB2 as the IRM database.
Over the coming months we will see more releases from this technology as we improve format support, platform support and continue the strategy to for Oracle IRM as the most secure, scalable and usable document security solution in the market.
Want to learn more about Oracle IRM? View our video presentation and demonstration or try using it for your self via our simple online self service demo. Keep up to date on Oracle via this blog or on our Twitter, YouTube and Facebook pages.
