DSXchange

I have a value from a file and in DS transformer that is varchar and I want to convert it to a number value so that it won't fail when loading into an Oracle table. Does anyone know what function I use to give me the equivelent of to_number in Oracle? And for knowledge sake, what is the to_char equi...

Its there...the layout in my post looks wrong...but the spaces didn't hold correctly

Yes those are the fields I'm joining or looking up on

they are both hash files...both input and lookup

the columns I'm joining on are both varchar(10) and contain values like Q13A.

not sure what else to give

no constraints...transformer looks like normal lookup..something like this: [b]Input File[/b] respid question [b]Lookup[/b] bp_file_ques_num--------- bp_file_ques_num bp_flag from there first 2 columns of Input are mapped to output and bp_flag from lookup is mapped to output. Very standard...just no...

not sure what you mean by that...

When I created the lookup hash file I Trim() the value in a transformer.

I then Trim() the key expression in the transformer that I'm using the lookup in.

Does that answer the question?

Thanks! but I Trim() both side and get the same result. both fields are varchar(10).

Try this:

OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:")

I've created a hash file lookup with 2 columns. Key column holds values like: 'Q13A' My input file has values the same as above. example: 'Q13A' I've open both files and manually verified there are matches values within both files. However, when the job runs I get zero matches?! No errors, just noth...

Thanks! Great information! I have another quick question. If I wanted to use your logic within each job, is there a way to set a variable from the return of a routine? Then use that variable within an SQL statement in an OCI stage? Examples would help if you have them. Thanks again! ----------------...

I'm unable to do this because my source table and the ExecutionStatus table are on different databases and I'm unable to use DBLinks. [quote="chucksmith"]Are you askiing for this: [code]select * from TableName tn, ExecutionStatus es where tn.last_updt_dt > es.ExtractLowDt and tn.last_updt_...

Here is the deal: I have several large tables I want to pull from. All these tables have a last_updt_dt field on them so I can determine when a record was last changed. So I could run the following SQL on the source: Select * From table_name Where last_updt_dt > #ExtractLowDt# And last_updt_dt <= #E...