DSXchange

I haven't ever tried using DSX files.

But i would take a report of both the jobs.The default template creates a HTML file. Then we can compare them easily..

what I mean to say is when I tried with FTP plug-in Stage, I needed to mention all the column name for the output link but i have the files in zip format. So I think file cann't be read until it gets unzipped. Morever according to my perception FTP plug-in stage doesn't copy the file rather transfer...

I tried to use FTP plug-in stage but later i came to know it trasnfers data of the file rather than transferring the file. Please send me detail property setting for FTP plug-in stage if it is possible to transfer the file (but i couldn't through it). ------------------------------------------------...

Hi,
I want to get trasnferred multiple zip files from remote location.
So I am calling a shell script which is having certain unix commands to execute the same. how can it be done in Datastage7.5?

Or is there any other efiecient way to do it?

Still facing the problem. Can anyone please take this & suggest some pointers?

Thanks,
Venky

Hi Ray, I didn't get u. How can we see that loop generating expresion. But my guess is...when we go to property of Start_Loop_Activity,tab 'Start Loop'. it is like this Loop Type=Numeric Loop(For Counter=n to nc step inc) Loop definition from=1 step=1 To=#Variable#.Counter (It is the variable) If it...

Hi Ray, Thanks for your input. Ya, End_Loop_Activity is having link to Start_Loop_Activity. There are many stages have been used in between the loop so the expression generated in Job Control is not looking me feasible to post here as the expression lines are more than 2000. Can we trace the porblem...

Job design is like this... I have to load several sqeuential files in a table. These sequential files are generated by a system on daily basis but sometimes if system doesn't generate file in that day then it is supposed to generate 2 files in next day & so on. To be more generic, there are mult...

Hi, I have a JOB which loads several no. of sequential files in a table. No. of files is not fixed ,it is a variable.So I have used START_LOOP_ACTIVITY& END_LOOP_ACTIVITY stages to load the same. Also, a Seqencer is used in the loop. But it is not working properly as it gives the message "E...

Hi Kumar, I had Initially Added a few parameters in some jobs and hence in the workflow as well. Later the desing changed and we deleted it from the job as well as from the workflow. Now the workflow is not getting compiled. It shows an error- Variable XXX never assigned a value. where XXX is the pa...

Hi all, The job control for workflow is not getting regenarated everytime i make changes in the workflow and recompile it. Does APT_COMPILEROPT Env. Variables have anything to do with it. The default setting is APT_COMPILEROPT is -dalign -O -PIC -library=iostream -c Can anyone explain what each opti...

Hi In one of the parallel jobs I had been using the config file as single.apt(1 node). The job uses a Oracle reads,Transfomers,JOIN stage and finally Oracle write. This job has been tested on the testing Environment. Now for Performance reasons I just tried changing the config File from single.apt t...

We faced some problem retriving some hased data. To resolve the same, we tried reindexing the project. But this goes on indefinitely .... any idea why this should happen? How much time does it take normally?

Hi Sam,

Tell us a few more things.
Has the job run succesfully ?

What is the data_type of the Key in Stream and reference links??
What is the option you have specified for LookUp Failed?

Please elaborate...

Regards
Venky

Hi My parallel jobs does some Gud ETL Functionality. :D The only problem is that some of Column's values are getting truncated in some stages (Like Varchar2(40) to Varchar2(30)) and in some later stages getting transformed back to the original length.(like Varchar2(30 to Varchar2(40)) So finally whe...