DSXchange

If you are using it inside a PX job, then it's not a BASIC function... unless you're doing that inside a BASIC Transformer.

No problem, Oracle always seems to march to the beat of a different drummer.

So, can we mark this issue as Resolved now?

Depends on the database and the stage used but the DRS stage seems to work 'more better' for stuff like this from what I've seen.

I haven't seen that yet but then I don't let the 'Posting' message stall for any length of time. I learned long ago that, for whatever reason, if you hit Submit and it doesn't post pretty much right away there's a good chance there will be some kind of issue - usually multiple posts but sometimes go...

That would be a CLOB field which is technically not supported. However, that doesn't necessarily mean it won't work. What have you tried? Perhaps an unbounded LongVarchar would do the trick.

Keep reading.

When i made the select query on the database the date field comes as 2009-11-18 00:00:00.0. This means that source date 2009-11-18 got converted into a timestamp. I am not coding column metadata in the job . So Please let me know which setting if required to be changed. I am not understanding why t...

The source dataset have some date fields with format 2009-11-18 . But when the data is loaded intp Oracle Table , it converts its format to Tuesday,November 17 ,2009 12:00:00 AM GMT + 00:00. So... are you seriously saying that 2009-11-18 is getting converted to November *17* or is that a typo? Obvi...

Stop trying to be tricky or clever and build separate jobs for each record type. Perhaps you could build a common header/footer validation job but I'm not sure I've even bother doing that.

Talk to your Admin for that machine.

A Server job writing them out using the Folder stage would make this trivial.

vivekgadwal wrote:However, all the rows with NULL Coverage_mp are being dropped by logging a warning.

Any particular warning?

And just in case you hadn't stumbled across this yet, stage variables in a Parallel Transformer do not support nulls. Server Transformer stage variables do, but not PX.

It's a normal flat file so you have a number of options on how to change it, especially if it is the only record in the file. You could use a job, do something in a routine, even a shell script.

Excellent, nice job working that out. Hope you properly chastised whomever gave you the wrong metadata.

Not nearly enough information for someone to help without guessing. :? Tell us exactly how you are creating / using this 'parallel routine', exactly where/when you are getting the errors you posted and what things you tried from the other posts you found. Oh, and it would probably help to know what ...