DSXchange

It dependes on how you use the search facility.

Though you have an option to split the Job sequence for group of jobs and trigger indiviually for good maintanability and clarity...
there is nothing wrong in calling all the job in a single sequence

Also check the teradata default timestamp settings.

RCP
Turn it off. Some times it might be turned off at project level, and may not be effective at job level. Care should be taken.

You can search this forum to get a better results. "Heap allocation failed" means that it couldn't get more memory when it demanded it. So it has spilled to disk, and continued to process, albeit not as fast. Check the disk space and memory using commands like df and tops. Also try running as root a...

Hi kumar Its working fine now.But could you suggest me how to take the latest row from that rows.Coz when i am using the Rem Dup stage its giving me the first row not the last row as i need. Thanks sam In both Sort as well as Rem Dup stage, the optiom to Retain First/Last are available in its prope...

Try if this works for you: Create a stage variable "Concatenated", initialize it as empty string (""), and it defined as: If Concatenated = "" Then Input.ColumnD Else Concatenated : "/" : Input.ColumnD Read through the sequential file and send the data to a hash table with 4 columns. Column A, B, a...

I could search 3 similar post, couldnt find any useful information in all the post.
dssh can be executed. $DSHOME/lib has been exporte in PATH (that is where libgciudt6.so actually resides).....

Three problems with that solution. 2. There's no column called NAME in the DS_JOBOBJECTS table. 3. It's more appropriate to change the setting on the DS_JOBS table, which does have a NAME column. UPDATE DS_JOBS SET READONLY = 'RO' WHERE NAME = '<<JobName>>'; Beware that DataStage SQL is case-sensit...

I guess it may not be easy using Job Sequence. But you can achieve the same using the shell through which the sequece can be called. Just frame a loop for 10 times and check for RC. If it passes call the next sequence where the Email notification present else rerun the sequence. Pass the status of t...

There shoulnt be any issue with the dataset as long as the max file size of the sequential file is permited by the OS. But if you are looking for Lookup file set with very large number of rows, it will certainly affect you performance. You need to take care of loading the fileset into memory. Your p...

kumar, Thibal would like to know some opinions about job sequences, that's what i did. And again, there is nothing wrong i said about you post. I just want to quote that there is the possibility to pass the parameter values to Job sequence it self. :D After all, this is a forum where we can all sha...

Hi Viny, Sevaral option available. You can change your whole project as Protected using administrator. By making this, only autorised user can access and modify the jobs. Or while you export using version control you can make your jobs as read only. Or at you risk you can change the UV files directl...

Hi, If you are much concer about the number of variables, you can also customize as follows. Previously i havent mention the Else part in the If condition. Make sure the current derivation is given Else you would get as you are getting. Tot_Pos = If Old_Name=InputLink.Name And Old_Add = InputLink.Ad...

HI Kris,
Could you just explain your requirement. It seems you need a job to be reset and rerun automatically before it splits out the abort message?