top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Converting the time column SQL server to timestamp column in oracle using Informatica

+1 vote
573 views

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?

posted Jun 18, 2014 by anonymous

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

1 Answer

0 votes

Once you read the column from the source, the Source Qualifier will convert it to PowerCenter-internal date/time datatype. All you have to do is connect it to Target Transformation with it's Oracle data types (in this case) and PowerCenter does the conversion for you

answer Jun 18, 2014 by Shweta Singh
Similar Questions
+1 vote

I am using below statement but i got error.
ALTER TABLE XXXtable
ADD xxx_name varchar2(50) not null;

error message:
ORA-01758: table must be empty to add mandatory (NOT NULL) column

0 votes

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.

0 votes

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?

+2 votes

I have two tables to join with a column (say emp_id).. if emp_id in both the tables have null values, how will SQL Server and Oracle treat???

I read that informatica will neglect the NULL rows when joining..if I handle the null, by substituting -1, a cross-join will happen which i don't want..

What can I do here? (I cannot completely neglect the rows which has NULL)

...