DSXchange

I'm sure you'll need to take the extra step to remove any 'Field Marks' from the output. So, either an ERplace or Convert to strip them before the check or... Stage_name.$CommandOutput<1> > 1 I have done that by using Trim(Stage_name.$CommandOutput) >=1. It looks working. is this the right way to d...

I'm sure you'll need to take the extra step to remove any 'Field Marks' from the output. So, either an ERplace or Convert to strip them before the check or... Stage_name.$CommandOutput<1> > 1 what are these field marks. why they appear in the output. Please explain if you dont mind. I hope this is ...

I'm sure you'll need to take the extra step to remove any 'Field Marks' from the output. So, either an ERplace or Convert to strip them before the check or... Stage_name.$CommandOutput<1> > 1 what are these field marks. why they appear in the output. Please explain if you dont mind. I hope this is ...

I'm sure you'll need to take the extra step to remove any 'Field Marks' from the output. So, either an ERplace or Convert to strip them before the check or... Stage_name.$CommandOutput<1> > 1 what are these field marks. why they appear in the output. Please explain if you dont mind. I hope this is ...

My job has a execute command activity connected to notification activity. I am couting number of lines in a file. This file name is passed as parameter in the execute command activity. If the count is more than 1, then i have to notify a team. So in the triiger expression type of execute command act...

ray.wurlod wrote:Even then, don't you need to use expr in the shell script?

Code: Select all

result=`expr $1 + 1`

In the after-subroutine how can we write specify unix Expr. we only give parameters and #parameter#+1 is not working when updating a field in oracle table

My Scenario is, i have to pick a parameter and update the same parameter adding 1 to it. How can i perform matematics in ExecSh after SubRoutine.i,e how can i add 1 to the parameter. if i use parameter+1, then the Updates value appears as parameter+1. Please help

I have an compressed file on Unix Box. Now i have to get the file onto datastage and do some processing on it. So first i have to uncompress the file and then do th processing. But how can i uncompress it using any stage. Expand stage does that when the file is on its input. Now through which stage ...

[quote="ray.wurlod"]There is ALWAYS partitioning. Even if it's done logically using shared memory. Which only happens in the case of the Entire algorithm. (Auto) will apply Entire if on the reference input link of a Lookup stage. The reason that Entire is the default is that, no matter on ...

If you use Entire partitioning on the stream input of a Lookup stage and there is more than one processing node, then - yes - you will get duplicates. If there are N processing nodes you will get N copies of every row. When talking about the reference link of lookup stage, there is no partitioning....

Of course you don't need to partition. Just don't expect correct results if you don't. Even in an SMP environment, you need Entire partitioning to make use of shared memory. If you choose some other partitioning algorithm (hopefully a key-based algorithm such as Hash or Modulus) then any given key ...

ray.wurlod wrote:This is really the same question as the one in this post which was also posted by you today.

Sorry abt that double copy.

Of course you don't need to partition. Just don't expect correct results if you don't. Even in an SMP environment, you need Entire partitioning to make use of shared memory. If you choose some other partitioning algorithm (hopefully a key-based algorithm such as Hash or Modulus) then any given key ...

Small Question Why we have to entire partition the reference data on Lookup stage? because we are loading the whole reference data into memory and what is the need to use entire partitioning. When we are getting whole data into memory, do we still need partitioning on reference link. When we entire ...

Generally we do the entire partitioning for reference links and auto for input.But my question why do we need to partition the reference link. however all the data is loaded int o memory, then there is no need for partition. Please clarify me regarding this.
Do we need to partition in SMP system.