DSXchange

DSguru2B wrote:Any warnings? Like nullable column going to a not null column, etc? Keep in mind, parallel engine is strict in this sense.

No Warning found.

I have some 50 k records which flows into a transformer(i/p link). I take a 2 links out of the transformer. There are no contraints mentioned in the transfomer, however I find a record mismatch b/w i/p and o/p links. any idea why it happens??

How to convert delimited file(comma delimited) to fixed width file?. Kindly advise.

richdhan wrote:Hi,

Search for handle_null.

HTH
--Rich

Can u be more specific please? I'm unable to identify handle_null

I need to convert a Nullable field to Non-Nullable field using a Modify Stage.

Kindly Suggest.

All, I get an error as stated below. node_node1: Fatal Error: Unable to start ORCHESTRATE process on node node1 (colby): APT_PMPlayer::APT_PMPlayer: fork() failed, Not enough space. Not enough space. - What does this mean? There is no space in /pxwork disc slice or There is no space in Virtual Memor...

ray.wurlod wrote:

Code: Select all

OutputColumn:int32=InputColumn 

or

Code: Select all

OutputColumn:nullable int32=InputColumn

Input column is of data type int64. This will generate "possible loss of precision" war ...

I get a warning when i tried to implement the idea. The warning needs to be avoided. What needs to be done here??

Can i have the syntax/example for Converting BigInt(Int64) to Integer(Int32) in Modify Stage.

When i run the job thru director i'm unable to limit the no. of records because the Option to limit the no. of records in the Limit Tab is disabled. Can some one suggest to enable this tab?

ArndW wrote:Does the file exist and if so, what are the permissions? Does your userid have write permission to that directory? ...

Its not a file its an Oracle table which I'm trying to import..

ArndW wrote:Does the file exist and if so, what are the permissions? Does your userid have write permission to that directory? ...

Its not a file its an Oracle table which I'm trying to import..

bkamila wrote:Log in as dsadm and run the job and see if you get the error. If you do not get error, then file permission error.

What is the password for dsadm..??

I get the error " Error Writing to RT_SCTEMP/RunParallel_8871.13981.sh" while creating the Orchestrate Schema. How can it be solved...??? Pl. advise..