DSXchange

When checking operator: When validating export schema: At field "BANK_KEY": "null_field" length (1) must match field's fixed width (40) The above warning is from a sequential file andto get rid of this warning I changed the null value to this particuler field to 40 in the column ...

I was passing job parameter which is RUNDATE and the datatype is String used in the parameter, but this parameter is used for jobruntime in the parallel job. In the sequence of this job the parameter is been given value in the uservariable stage as DSjobruntimeStamp. Finally when I run the sequence ...

I used sequential file to capture the rejects using CSV format.

Is there any option in the properties of sequential file to not to create any file when there are no rejects.

As of now whether there are rejects or not files are being created.




Thanks

In the simple job which I said the stream has 100 records and the reference has 10000 records I changed the query in the reference using where per_id=orchestrate.per_id and when I run the job I receive an error main_program: (aptoci.C:456). Message: ORA-00904: "ORCHESTRATE"."PER_ID&qu...

Thanks for all the information!!

So in the input value of that option I need to give the path of the file where the script is located?





Thanks

Thanks, I have a notification activity at the end if the sequence job,so can I use execute command after that. also In the parallel job properties>general there is an option after-job subroutine with drop down executeSH and needs an input value. can I use that also,just wanted to know about it. Plea...

After running the sequence job at the end I need to call a shell script to move the rejected files to an other folder i.e archive them.

please suggest me how can I do that?




Thanks

Thanks

Do we need to use that in the query of reference table for the key column from DB stage?

I am using sparce lookup with oracle enterprise stage, it gives more number of records than expected.I tried a sample job with stream 20 records and reference 200 records and the output I get is 2000 records. The two key columns have been selected as keys in the input of lookup. please suggest if an...

Thanks Jwiles that worked.

Instead of using different number of stage variable I tried using

Svcurr- col1:col2:col3:col4:col4:col5

i.e concatenating the fields in an order, Is this change OK to use.


Thanks

So instead of using second sort stage I need to use transformer to find out the changes in the fields of each key till the second group occurs with different key, something like svprev--svcurr svcurr- svvalue--If svprev=svcurr then 0 else 1 So when value is 1 then I will pass the records or else ...

In an input of 10 fields the ID and updatedate are two fields which have been already sorted and also removed duplicates having same ID and updatedate. After they are sorted the records are passed to another sort stage and there I sorted all the fields except the date field i.e 9 fields but used opt...

stagevariable derivation svprevvalue svcurrvalue svcurrvalue svvalue If svCurrValue <> svPrevValue Then 1 Else 0 In the constraint I will give svvalue=1 As I need only the records where there is change in any one of the fields except the date field Only thing I am not sure is what will be the svcurr...

There are 10 fields from the source which have a key column and updated date. Lets say the key column is 123 which has 4 records with some changes in the fields and updatedate. Using sort stage the records are sorted with the key column and update date. Now used an other sort stage to generate the k...