DSXchange

Hi,
I have Numerical+Characters data in the source in the same column. Data type is varchar and it has values like 19, 'ABC'. How will I load only Character data to the target?

Thanks a lot!!!!

chulett wrote:They only have an "extension" if they are multi-instance, that's when you add the "dot" and the Invocation Id to the name. Otherwise, it's just the name. ...

Thanks Craig. On this can you please tell me how do I make a job multi instance?

Hi all,

Can anybody help me setting up default parameters for my sequence? I need to set up data base connection credentials at sequence level.

What is user variable activity stage?

Thanks!!!!

one more question please, what is extension of jobs like dataset has extension .ds?

Hi All,

Like we submit a data stage job from unix using dsjob command, how can i submit a project. My project has 10 jobs. have created a sequence too. How do I submit it now? so that all of them run as per their order in sequence?

How to track performance statistics of parallel jobs? I know when we run it we can see number of records being processed at what rate but how do we actually check how much time job took to complete etc?

Hi All,

Just wanted to follow up on the same if any body can help me out on this?

chulett wrote:

agpt wrote:Can you please tell me what Column[3] does here exactly?

Without the starting position, it starts from the end so that means to substring off the last 3 characters from t ...

Hi Chulett... Sorry I couldn't read your whole message but I think I got the answer to my question. Thanks a lot!!!!

hemanthakumar wrote:i used dcount and field functions. Its working fine :D

Hemanth,

Can you please give the exact syntax you used?

arunkumarmm wrote:Or you can try

Code: Select all

 If Count(Column,'_') > 0 Then Column[3] Else Column

Hi Arun,

Can you please tell me what Column[3] does here exactly?

Hongqing Tang wrote:Yes, I am sure I am the only user at this time.

did you try restarting you DS client or your machine?

Sainath.Srinivasan wrote:Yes

Sai,

Please elaborate how to achieve that...

use transformer

anbu wrote:datisaq is the username.

ArndW was replying to datisaq's post above

Oh Sorry... I didn't notice that.