DSXchange

No Idon't see any other message othern than this

All, We are extracting the data from Netezza and loading into oracle DB. We able to extract the data from Netezza to File and File to Oracle successfully. But when we try to load the data directly using connector stages Netezza to Oracle it is through below error Operator terminated abnormally: rece...

I have validated all the date constraints. I have pasted the same sql in toad and DS and there is no constraints on Transformer. The records were missing in the ODBC stage it self. Source DB is Oracle.

craig,

I am not able to find the ans in the previous post. can help me on this

I am working on converting the server job into Parallel job. which is using Aggregator stage in it. Its running fine with the following warining (APT_CombinedOperatorController(6),1: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large fo...

Convert is working for this.....


Thanks for the Help

HI,

I have input string as alphanumeric string which is ex: xxyyzz1212xxx.
I want o/p like 1212.

we can do this in Server job using oconv. can we do this in parallel jobs.
can any one help me?

Hi,
can you please tell me how to handle nullable field in seq file.
when i running a job in parallel.i am getting the following warning.

Null field handling without nullable properties

Thanks for u r help in advance

Hi
iam getting the souce data in flat files.
i have to join those flat files on particular colums and derive the new filed for one of the flat file..
its a huge data can i use lookup for this
merge i tried but its saying that this stage can't take any input links
how can i do that in server jobs

Hi
i have to join 2 table table to derive a new filed in 1 table..

is there any other way to do join(with out using any odbc stage)