DSXchange

Yes,you can use the parameter

Table name has additional characters like space at the end of it.so check the table name given in the oracle stage.

Check if all links are linked in the job.Some link in the job is not linked to any stage.

In the transformer stage, give the constraint to check for isNotnull() of all 7 columns.[ IsNotNull(col1) And ...IsNotNull(col7) ] .

The error message is:
Sequential_File_1,0: Unable to open /data/etldata/etl_parameter: No such file or directory.

The path is not parameterized.it's simply given as /data/etldata/etl_parameter

The main Sequence aborts with 'no such file or directory' error.The sequence calls a job which loads to a sequential file.The file update mode is set to Overwrite. The sequence has failed this time only with 'no such file or directory' error.we recompiled and re-executed the sequence ,it executed su...

what should be done to make the job run without the truncation failed error?

A job is designed with a source oracle stage loading to a target oracle stage through a transformer stage.When the job is executed it aborts with the below error. Target: Table truncation failed for "SCHEMA.TABLENAME". Is it a database issue, i.e - Privilege to truncate the table is not gi...

Which stage are you using to extract the data?If it's Oracle OCI stage then the array size can be set to the maximun value(32767) to improve the performance of the job

Yes,a single job can be designed to both insert and update records

When performing an aggregation using the aggregator stage,the output column's datatype will be dfloat by default(internally) though you have mentioned the DUPLICATE_REC_COUNT field's datatype as Integer(10) . So, mention the aggregation field's output datatype as Double(20) and then use a transforme...

For INT_DATE field & WCOUNT fields you must have used some derivation in the transformer stage which doesn't return a timestamp value(yyyy-mm-dd hh24:mm:ss) or an integer value for those fields respectively.Check what values are generated for those fields.

The Unicode property for COL1 is set in the input link while it's not set in the output link in a particular stage.So either use it or remove it throughout the job flow(from src to trg ) .

The sequence runs once everyday.Then will not the same customer having 2 incoming records with the amount deposited and amount withdrawn details be looked up and considered as 2 new records?If so, how to generate unique records for the same customer?

If you want to set a Not Null field to a blank space then you can simply give " " in the transformer stage.It's a blank space. Or if you want to set a blank space when the input column's data is Null/no data use the below derivation in the transformer stage : If IsNull(inputcolumn) Then &q...