DSXchange

I tried that but dint work because in there I have to select a column to trigger.Every field has different records & it is not pssible to do like that in my job. Instead I tried @INROWNUM function in transformer stage. I gave as constraint for first file as @INROWNUM < 400000 & for second li...

I see the Triggers in Transformer stage but I have no idea what to perform on that?

Can you please tell in detail what should I give there?

Hi, When I write the data to Sequential file ,it runs without aborting. But when I try to write that to XML Output,the job aborts with error message no enough memory. The total record count is 1822963. So I want to split and write to XML output stage?CFfStage->Transformer->Xml Output(2). I think we ...

Yes,I got the answer and I also set the Nullfield value for each coulmn in file thats when i was able to view the data.

Thanks a ton everybody !!!!!

I doubt it does. The job may be 'running fine' but is it processing any records? Are all the fields in your flat file defined as Varchar? That or the file is empty. :wink: ... Yes..there are records getting populated in the file. I see the warning message in log as "APT_CombinedOperatorControl...

HI, Job is running fine without any errors/warning.The target is flatfile stored in .csv format. When I right click the file to view data it gives me error as "No rows were returned from the view data server command. would you like to view the commands output?. If I click yes then it gives me &...

Thanks a lot for all your Quick Replies.

Inside the User Variable Activity,I want to Concatenate One User Variable with the expression value for another User Varaible. Inside User Variable Activity I have two Variables : 1.ETLROOTDIR (The expreesion for this variable is extracted from hashtavle using UtilityHashLookup ) which is /mdm/dev/d...

Yes,I even tried to select from "Insert Parameter' but it didn't show me the list of User Variables in there to select.So I dont think so I can use one UserVariable within the Expression of other Variables.

I did try the expreesion UserVariables.A:'/jkl/mno/pqr' for varaible "B" but it says Variable 'UserVariables.A' not defined.

Hi, It looks very simple.But it doesn't work and I tried lot of other combinations.I In User Variable activity,under Name tab for Variable "B" the expression which I gave was 'A':'/jkl/mno/pqr'.The outbound that I get is A/jkl/mno/pqr. But the Value of variable A is not Concatenated. I eve...

Hi All, I have defined multiple User Variables in my sequence.I am getting some parameters from Hash Table using UtilityHashLookup. I have a User variable "A" which is extracted from Hash table and its value is abc/def/ghi. I have another User variable "B" and its avlue is abc/de...

Hi All,

The job aborted with warning "ds_uvopen()-unable to read file header ".The source for this job is Sequential file.I believe the issue is with files.Can anyone please help.?This happenend in production.

I have created User Variable Stage and the expression I had given there was downcase(ENV).
Is this correct?

Hi All, I am using an Execute Command activity in my job sequence and calling the parameter within the sequence.I wanted to convert the parameter into lower case.Is there any way that I can do in the sequence. The reason for it is we have 5 different environments.Each time we migrate the code,we hav...