DSXchange

Thanks.....

Try to use the following function: Index(%string%,%substring%,%occurrence%) %String% ---> Original String. %substring% ---> patern you are searching for. %occurrence% ---> you can hard code it as 1. Use the above function in SV1. And later put a constraint that SV1>0 then process the records, else r...

You need to use Source, destination and LKP.


Source -----> Lookup(Transformer if you are building Server Job) -----> Destination


@Ray/Kryton - I thought that it could be done by query but wasn't sure how. Could you guys please show me the query.

Hi, You will have to do self-join. The first 3 columns will remain the same and in the third column you will do a lookup and see if there is any lead to the correspoding employee. And if there is then you will append with a comma. For example, empno | empname | lead name | manager name 101 | John | ...

Initially you will have to convert the TimeStamp to String using TimestampToString(%timestamp%,[%"%yyyy-%mm-%dd %hh:%nn:%ss"%]) function. After wards you can apply your substring function. But, as Chulett said your syntax is wrong. It should be as shown below: in.column[1,4]:in.column[6,2]...

Before trying to run the job on Single node.
I would recommend to select clear option in Preserve Partitioning in the stage before the Sort Stage.

And still the issue persist then try to run the job on Single Node.

Can you show us the SQL which you are using.

Priya, Initially I was also missing the XML stages when I was missing FP1. But, after installing FP1, I could see all the XML stages. And today I tried to build another job using XML Stages and they are running fine when there is an input link to the XML stage. But, the job aborts when there is no i...

Ernie, I also thought that there should be some update in FP2. IBM has put out FP2 early this year. I have FP1 installed on my machine. And I have downloaded FP2. I am going to try to install it today. Because, I try to ran the job which IBM has put as an example. But, it is also giving the same err...

Why don't you try using Surrogate Key Generator. Check out the link below: http://dsxchange.com/viewtopic.php?t=145833&sid=dd30327e42b149742fe299ffeda35239 I am also facing some problem with Surrogate Key Generator. But, it will give you consecutive number to certain extent. I have opened a PMR ...

Do you have a Server job or Parallel job?
If you are using Parallel Job. Then did you try using Surrogate Key Generator?

Do you have a Server job or Parallel job?
Did you try using Surrogate Key Generator?

Hi, I am trying to use the new XML Stage in DataStage 8.5. I imported the XML Parser job from IBM's website. When I try running the job. I get the below error: Department: [Output link 0] Java class not found: com/ascential/e2/common/CC_Exception (CC_JNIException::findClass, file CC_JNIException.cpp...

Put a transformer and do Ramesh's logic as shown below:

If IsNull(string) Then SetNull() Else StringToDecimal(string)

After transformer put a Copy Stage and write into Target Table and also write in Sequential file.
And check in Sequential file if you get Null.

When you import the file in Excel at that time select EFFECTIVE_DT as TEXT columns and not General.
And try to open the file in Textpad or Notepad and I think it should show you the correct date as in the Source file.