DSXchange

Hello all, I have the following scenario Source file - transformer - look up database (being looked up sparse look up )-output The idea is for each row value (varchar) , I need to to break the string into words (which I am handling with loop variables) and look up each word to database to get matchi...

That helps . Thank you Shane and ArndW.
I was infact already doing a space (as suggested by Arnd)to lower the number of checks , I still wanted to test the looping (as I was doing it for the first time)

This works fine , thank again for all your help.

Thank you Ray and Shane. I have a few of these conversions (replacements) so I can choose to use the change or ereplace , however , i wanted to see if something like looping will work too , that way , I can perform a search and replace For example Instead of STRING 1 = 'A SAMPLESTRING' the string is...

Hello all, I have a logic where in a string say SET 1 STRING 1 = 'A SAMPLESTRING' STRING 2 = 'ASMP A STRING" STRING 3 = 'ASMP STRING A" SET 2 STRING 1 = 'AB SAMPLESTRING' STRING 2 = 'ASAMPL AB STRING" STRING 3 = 'ABSAMPLE AB" The rule is in a given string if it is either appears ...

Ok Thank you .

Thank you Craig , that works .
This resolved the issue , however , I am curious if somebody recollects the function that can allow us to specify the scale.
I will keep this post open for a while before marking it resolved.

I think i was able to search for a similar post (searched before but could not find it in first instance) http://www.dsxchange.com/viewtopic.php?p=253139 I think in when I try to convert something like 33333 ,it is not possible to get the data as 5,3 as there are only 2 chars (digits) on the left of...

Sorry , I think i didn't get you. I am doing a string to decimal conversion so , isn't the input field suppose to be a string ?

Hello All, I have a simple test job where I am trying to convert a string (CHAR 5) into Numeric ( 5,3) oracle table RowGen-->Transformer-->Oracle I referred the documentation but still feel that I am doing something fundamentally wrong here Transformation is StringToDecimal(inputfield) Output field ...

Hello All I have to funnel two fields one of which is oracle timestamp and other is Date field into a target which is timestamp. When I do a query the date (source column) the date appears to be in this format 11-DEC-2006 . To convert the date into timestamp I am using Timestampfromdatetime(source_c...

Craig I think when I wrote "Now string to timestamp function will work only if the format matches the timestamp , however , I can append a time and then use this function but i don t want to do it " I kind of started on the wrong foot. What I realize now and (after successfully testing) Th...

Craig I think by direct way I was trying to find out if there are any functions or logic that would handle this scenario . When I add or concatenate the incoming string - It is for me (manipulation in terms of format i.e I am adding something to the string ) . I hope I am clear. My incoming source i...

Sure , I will if I do not find another way - I wanted to see (learn )if anybody knows (or there is a way in DS ) of a direct way to do it .

Thanks pavi

The problem with doing this in oracle stage is that I have to combine (funnal) data with another oracle table that has date as datatype prior to load it to oracle .

If I do not take care of this I cannot funnel data without warnings.

Hello All I have searched the forum and saw a lot of posts relating to string to time stamp conversion but not precisely what I need . Oracle takes date field as timestamp . In my job I need to load oracle table with a date field (metadata in DS shows as timestamp) from a string which is in yyyymmdd...