DSXchange

There is a requirement where there are two jobs. One job loads a dataset. And another job loads from the dataset to a table. The first job should load all records into the dataset but if there are any 'error' records , the next job which loads from the dataset to the table should not run. The only w...

Are you getting the error message 'permission denied'? Does both userid's have same execution permission for that folder/file ? This can be the reason. No that's not the error... the error message being shown is : Dataset,0: Fatal Error: I/O subsystem: Open of /Folder/Folder1//Dataset.ds.dsadm.etlt...

Hi,

This might sound like a stupid question.. When a job is run loading a dataset using one userId, and you try running another job reading from that dataset using another ID.. Will this cause a problem ? One job is aborting and I have a feeling that this could be the problem..

Lookup Stage : Take key column from primary link and also take column from the reference link. The column derived from reference link will be a NULL (if nullability of that column is set to 'Yes' else the appropriate null default value will be set to that column (e.g. 0 for an Integer). Place a tran...

In the Lookup stage goto Stage->Advanced->Set Preserve Partitioning Flag to 'Clear'

I have a job which aborts immediately and the error shown in the log is:

main_program: Fatal Error: The input interface does not contain component "sortRec".

Any idea why this could be happening ?

Thanks in advance

incoming rows --> Copy --> Aggregator (group key claim_id,Aggregation = Sum) | | | | | | | | | Filter (On Sum = 01) | | | | | Merge------------------------>output | ^ | update link | |--------------------| God I dont know how to align the design above. Anyway .. just put a copy stage for the incomi...

ivannavi wrote:I apologize. It's there. How do I delete my post?

You dont need to delete your post.. It happens ... But you could mark this post as 'Resolved'

I added this parameter to a job, but in director I see it still uses the default value for the project (environment variable settings entry in log, and job monitor is showing 3 instances instead of 6 I was hoping for). Anyway this variable is not showing in job/parameters/add_environment_variable, ...

Add the APT_CONFIG_FILE environment variable to the job.
Set the default value of APT_CONFIG_FILE to the configuration file which you want to use.

If I understand your question, you want to know what "auto" partitioning does. I usually explain "Auto" as "Don't change partitioning unless the job decides it must do so to function correctly". In your example you've hash partitioned in the transformer. This sets up t...

Hi, I have a job design which looks like this: DB2 stage -----> Transformer ------> (rest of the job) (1 node) Now the link from the DB2 stage to Transformer has a hash partitioning method with unique sort. The key used for partitioning usually has distinct values with values recurring ocassionally....

Hi All, I am trying to load data from sequential file,which is having null values. After importing the table definition, and at filed level i am defining null value also, I am unable to get the view data. Why? Please clarify my doubt. What exactly do you define a 'null value' in a sequential file t...

No it cant.
Read up on the Sequential File Stage and DataSet stage in the parallel job developer's guide.
The usages and functionality of the two greatly differ.

I have a Job Design which looks like this INCOMING->Merge->Merge-(hash,unique sort)->Lookup->rest->DataSet All Merges and Lookups have a DB2 API stage as the master link and reference link respectively. Lookup stage and DB2 API stages are constrained to 1 node. I'm getting the following warnings whi...