DSXchange

It is giving error because you are sending the column with out handling its null values.Either use IsNull() or NulltoEmpty() in the transformer stage or handle_null() in the modify stage for that particular field before doing lookup.

Hi all, In one of my job i am using Oracle OCI stage to pull data from the source system. I am doing a simple left outer join based on date constraints. When i am executing this SQL from TOAD it is taking 15 minutes to complete but In DataStage it is taking almost 1 hour 10 minutes. My job design is...

Criag is right about it. Here is the how you can tweak this. Just remember what format you need at the output. OConv(IConv(Col1, "DYMD[4,2,2]"), "D/MDY[2,2,4]") : " " : OConv("Col2[1,2]:":":Col2[3,2]:":":Col2[5,2]", "MTS") With th...

Your syntax seems to be correct. What is your source and target datatypes and formats for this field?

Your answer lies here:

I generated the text file in windows and trasferred it to the unix server .

[/code]

Sorry its my bad. You can substring the time part and concatenate it.

Just try this piece: Oconv(Iconv(InDWWORK.DW_ADJ_DATE,"DYMD[4,2,2]"),"D/MDY[2,2,4]"):" ":InDWWORK.DW_ADJ_TIME Check for the timestamp format at the output, if needed append the milliseconds. Two other things which need to be considered is Null- Handling and Input date f...

You need to define the record delimiter property. Check what process is generating the input file and are you able to view the file properly outside datastage.

What format properties are you using?

Just do some tweaking with the code:

You can try stringtodate() in transformer stage or date_from_string() in the modify stage.

Just remove / from the code and it will work.

How are you handling the null values?

Great job. Keep it going.....

Yes, you can. Isn't Last time Ray posted you the syntax for that.