DSXchange

I did the same way that you explained but when I try to pass value for the nulls it's giving the fallowing error.


Error in output column derivation expression for column 'B' in link DSLink83. Invalid conversion requested from a int8 to a timestamp

Hi- I am having a problem when I try to have a lookup with a field to get a key. The source field I have is 'A' with a CHAR datatype and the lookup table lookup field 'B' with a TIMESTAMP datatype When I try to join these two fields to get a new field it's giving lot of errors. I tried to change the...

What is that indexing issue.
I am just curious

If I create with different name it's allowing me to create

Yes, I tried to do that but it's not allowing me create with the existing name.

Once I finish writing it I saved it and compiled it.


Thanks

Yes, I got it.

Thank you somuch

I am the only one who created .Nobody created userdefined routines here.

I did that somany times but still I don't see it.

Hi- In the repository under the routines I have created one category in that i have written one Routine with a name test. And I am calling that Routine in a routine activity sequence stage I am giving that routine name it's working good. my question is I want to edit that routine But I don't see tha...

Hi,

What is the function that we use for converting string to integer.
I don't see that funtion in the transformer

Any help?

Thanks.

Thank for your reply narasimha.

I got the same error.

Sorry, i did not get you.

"ora.974848.772490.0.log" 170 lines, 9371 characters SQL*Loader: Release 10.2.0.2.0 - Production on Sat Feb 17 17:40:33 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: ora.974848.772490.0.ctl Character Set WE8ISO8859P1 specified for all input. Data File: ora.9748...

"ora.974848.772490.0.log" 170 lines, 9371 characters SQL*Loader: Release 10.2.0.2.0 - Production on Sat Feb 17 17:40:33 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Control File: ora.974848.772490.0.ctl Character Set WE8ISO8859P1 specified for all input. Data File: ora.97484...

ora.974848.772490.0.log