top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica using Oracle database

0 votes
416 views

We are bulkloading few of our target Oracle tables. Many of our tables had one column with datatype timestamp(6) with local time zone. when we insert just the date value(mm-dd-yyyy) then target database is defaulting the hh:mi:ss to 11:00:00 PM. But when we make the load type as normal then the it is inserting 12:00:00 AM in hh:mi:ss part. Could someone explain why this is happening?

Thanks in advance.

posted Apr 28, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

I'm going to take a guess and say your ETL server's datetime is one hour different to the Oracle Server, or it's set to the same time but in a different time zone. I can't quite put my finger on the mechanics of this but it's worth checking if that's the case - they you can look into exactly why you're getting this effect

answer Apr 13, 2015 by Manikandan J
Similar Questions
+1 vote
Converting the time column SQL server to timestamp column in oracle using Informatica

I have a Time column in my SQL Server table which has data like (14:00:00.0000000).

I am trying to load this type of data in Oracle table which has corresponding column datatype as timestamp. I am trying to convert the time column in SQL server to timestamp column in oracle using Informatica.

Whats the best way to do it?

+2 votes
Database driver error when loading data with Informatica into Oracle XE 10 g

I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:

CMN_1022    Database driver error...
CMN_1022 [Database driver event...Error occurred loading library [pmora8.dll]. System error encountered is 193. Error text is %1 is not a valid Win32 application.
.]

Any ideas what might be causing this error? My environment is as follows:
•Windows Server 2008 R2
•Informatica PowerCenter 9.5
•Oracle XE 10 G

Powercenter repository is on SQL Server 2012.

0 votes
I want to install SQL Server database in my system and add this database to Informatica which has oracle already

I have Informatica 9 and an Oracle database in my system. Now I want to install a SQL Server database in my system and add this database to Informatica.

Is that possible ?

Purpose: I need to migrate some of the tables from SQL Server to Oracle database using informatica.

Could anyone let me know, after installing SQL Server, how can I add this SQL Server database to informatica for creating mapping?

+1 vote
Polish char is getting changed to a differerent char when loading into Oracle

I'm loading a file into oracle DB 11g via informatica 9.

The source file contains a polish char in a column given below:
US1_GPBAS - GPRS - dostęp do publicznych APN
When loading into DB, it gets converted to following data:
US1_GPBAS - GPRS - dostęp do publicznych APN
The file encoding of source file is UTF-8. In the DB NLS_CHARACTERSET is AL32UTF8

What could be the issue here.

...