DSXchange

I'm designing a datamart that takes data from various sources and load into a couple of tables which structure is connected with some constrainst. That means that: 1) I need to load tables in a certain order (master first, detail after) 2) I need to load tables in a unique transaction to avoid incon...

chulett, I set the NLS_LANG variable a user defined variable and added it into my server job. The problem seems that after XML-Input stage, the data are not correctly interpreted. seqFile1(xml)-->XML-Input-->Transformer-->seqFile2 In seqFile1 the TM symbol is correctly encoded with 3 bytes. In seqFi...

Hi All, my Server job reads an XML file with correct uft-8 encoded character (i.e. the Trade Mark symbol is correctly encoded with the 3 bytes e284a2). After the XML-Input stage, that split not all data, but some xpaths, I found not correctly character encoded (the same TM symbol is transormed with ...

i don't think of misspelling...
variables name imported as job parameters from same environment.
saved in the same way on 2different jobs.
imported not typing, but picking them up from job variables...

i cannot see a misspelling.

did it, but setting to $PROJDEF does not solve my problem

no default value... it's environment variable, encrypte... cannot set to $PROJDEF... i just see ******* now i found a walkthrough... i call, from my sequence job which cannot see the variable, the sequence one which sees the variable... and it works! but i wanted to understand why so a strange behav...

Hello. i have some passwords saved in environment variables. Trying to load them, in some cases (cannot understand which ones) when i read environment variables settings at the beginning of the sequence job, i can see some of them are shown by DS with encrypted value... but some is shown as '' (blan...

how can i delete other topic??
that was a mistake. i already replied saying it was wrong.

Hi all, i am trying to import an xml file. i imported the base structure with xml meta data importer. 1 - used a file beginning with <myTag> 2 - used a file beginning with <myTag xmlns="http://myUrl/path"> now i have to load a file, which will be in the 2nd form (beginning with <myTag xmln...

SORRY!!!!!

Hi all, i am trying to import an xml file. i imported the base structure with xml meta data importer. 1 - used a file beginning with <myTag> 2 - used a file beginning with <myTag xmlns="http://myUrl/path"> now i have to load a file, which will be in the 2nd form (beginning with <myTag xmln...

it' still me :) i am trying to put a constraint in a transformer: if parameter value = 'Y' then write file and go to collector also; otherwise just go to collector. that's for test and logs sake.... how can i evaluate a string? VARIABLE = 'Y'? if variable is 'N' the file is written... that's not goo...

my mistake, my mistake, my enormous stupid mistake!!!!!!

FOR NEWBIES: DO NOT PUT SPACES BETWEEN ATTACHMENTS LIST :
"attachA,attachB" not "attachA, attachB"!!!!

sorry
A.

your answer would make sense, but still i got 2 doubts:
1- how to write a script? i am quite new in DS, not so able in writing scripts... any help would be appreciated
2 - and.. if i have 8empty files and 2 full? the error comes again... i should check for any file if could be attached...

Hi everybody... i have a problem with DS.. i create log error files as #path#/#RoutineActivity.$ReturnValue#_error.log... so, as you understand, log names are dynamic every run of the job... then i go back to my sequence and send notification mail with these files attached. But, if these files, even...