DSXchange

Any clue as of why this is happening? I tried changing the key of the oracle table but it dosent work. The key previously was the MACRO "DSJobStartTimeStamp" I'v chosen this one because the job start time is never the same usually. Now i have changed it to the current time stamp using OCON...

Any clue as of why this is happening? I tried changing the key of the oracle table but it dosent work. The key previously was the MACRO "DSJobStartTimeStamp" I'v chosen this one because the job start time is never the same usually. Now i have changed it to the current time stamp using OCON...

Changing the keys dosent work , I changed the key to the current system time column. it dosent work too .

Any suggestions ?

GOOGLE SAYS: This error is issued if a user tries to insert an already existing value into a column defined unique. Cause: This error means that an attempt has been made to insert a record with a duplicate (unique) key. This error will also be generated if an existing record is updated to generate a...

I have changed the statement into Left(I_SBN_Merch_Contr_Rules.BMC_TS,10):' ':Ereplace(Left(Right(I_SBN_Merch_Contr_Rules.BMC_TS,15),8),".",":") and also (6,2) as Ray mentioned. But now the job gives a new Warning: TESTBMC2..Transformer_11: ORA-00001: unique constraint (ETQ.PK_VA...

I_Server_Whale wrote:

DSguru2B wrote:Thats not long winded.
This is long winded

Code: Select all

Left(in.Col,10):' ':Ereplace(Left(Right(in.Col,12),8),".",":")

That's much better one !!

How about this?

Code: Select all

In.Col[1,10]:' ':Ereplace(In.Col[12,8],".",":")

Whale.

NICE !!!!

There are no fatal errors, it just shows that o rows have been transferred. There are warnings though ! TESTBMC2..Transformer_11: DBMS.CODE=ORA-01850 TESTBMC2..Transformer_11: The value of the row is: PROCESS_ID = 2 SUBPROCESS_ID = 17 MEASUREMENT_ID = 50 PROCESS_TIMESTAMP = 2006-11-30 28:33:99 SUBPR...

Note: It is a single space between the single quotes in the above code.

I know thats a very long winded logic but the thing is I also need to trim the "." and give ":" in their place.

I am using all the 4 statements mentioned as stage variables and giving the final output to the column where I need the timestamp.

I am loading data into a OCI-9 stage and I have 3 timestamp fields in that OCI table. In the 1st one we are giving the macro " DSJobStartTimestamp ", The second one We are giving the current timestamp as OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS&quo...

The Oracle field is "TIMESTAMP"

I think the problem is with the length of the original date, it looks like "2006-11-22-11.40.11.801933" . i can get it to look like "2006-11-27 18:07:35 then i think it should work.

I am getting the date mentioned above from a Complex flat file which shows the Native type as "character" and i need to load it into a OCI 9 stage where the table definition shows the field as "Timestamp" . Can i change the type in the OCI table definiton into "DATE" ?....

This is the timestamp i need to convert to load into a OCI 9 stage. Can anyone tell me how to convert it ?... and also what is the ORACLE time stamp format ?

2006-11-22-11.36.51.535212



thanks

having problem loading the data into oracle database. the job runs successfully but not loading the final data into the database . the link to the database doesnt show any info. in the log files it shows as Type:Control Event : finished job Type :Reset Event :Log prior to last 2 runs cleared by user...