top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Time value as output

0 votes
285 views

For few columns from the source i.e .csv file, we are having values like 1:52:00, 14:45:00.

I am supposed to load to the Oracle table.

Which data type should I choose in Target as well as source?
Should i be doing any thing in the expression transformation?

posted Sep 2, 2014 by Sunil

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

2 Answers

0 votes

Use SQLLDR to load the data into database with the format described as in the link

http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm

ie.'HH24:MI:SS'

answer Sep 3, 2014 by Shweta Singh
0 votes

Oracle does not support time-only values, it supports dates (with a time component). You have a few options:
1.Store the value as a string, perhaps providing a leading zero for the hour.
2.Store the value as the number of seconds (or minutes) past midnight.
3.Store the value as the time component of some arbitrarily defined date, for example 0001-JAN-01 01:52:00 and 0001-Jan-01 14:45:00. Tell your report writers to ignore the date portion of the value.

Your source datatype will be string(8). Use LPAD to add leading zeroes.

answer Sep 3, 2014 by Shweta Singh
Similar Questions
0 votes

What will happen if the SELECT list COLUMNS in the Custom override SQL Query and the OUTPUT PORTS order in SQ transformation do not match?

+1 vote

In Informatica's PowerCenter, is it possible to set a parameter's value based on the output of a stored procedure? The parameter I want to set is a parameter I defined in a flat-file data object.

+1 vote

I have created a informatica workflow. The target is made as a flat file. The delimiter used is \037 with UTF-8 encoding, but the output file created contains , as the delimiter. It works fine with other WF's i have created.

How to get the required delimiter in the output file.

0 votes

I know this may seem like a basic task, but I cannot find any documentation regarding this.

I have an output port after a set of transformations (Filter/Joins/Aggregates/Joins/Filters) and would like to use an output port twice going into 2 separate transformations.

Is this possible from all transformations?

Anything I need to watch out for?

Thanks

...