DSXchange

How can I capture the status of job from job Log(basically a part of log msg like 'no of recorded inserted in table') and send it as subject of mail notification in DS sequence stage,using routine (BASIC/C code)

Can anybody please tell me how this javapack work? Does it come with DS PX?
I am new to it.Can anybody give me brief idea (function & how to use) of it.
Also can suggest me so site for it.
Thanks

Thanks for reply.But I could not see your complete answer.
Thanks once again.

Can anyone please explain me what is meant by Data element...
Thanks in advance.

How to add a new user in an already existing system in DataStage.

So having an index will improve performance. So SQL order by clause should give better performance than DS sort Stage. But in real scenario, in one of my job DS sort stage is performing better than Order by clause.So I just want to know how DS sort stage work internally(i.e. internanal processes inv...

Hi,
Can any one tell me why Order by clause gives better performance than Sort Stage of DataSatge. Basically how Sort Stage of DS works.

Can we call it in normal Transformer?As in my pallate I am not able to see Basic Transformer(Parallel Extender 7.5.1) and in my source data one date column is coming as '1-Jan-2000',(Source is sequential File) and I need to convert it into dd/mm/yyyy format .I wrote a server routine for converson,bu...

Can we call it in normal Transformer?As in my pallate I am not able to see Basic Transformer(Parallel Extender 7.5.1) and in my source data one date column is coming as '1-Jan-2000',(Source is sequential File) and I need to convert it into dd/mm/yyyy format .I wrote a server routine for converson,bu...

Is there any way to see Usage Analysis of a table in datastage,if metadata of that particular table hasn't been imported(present ) in DS manager,but the particular table is used in DS jobs.
Thanks in advance

Hi,
In datastage we use Pivot stage to normalize data.Is there any stage or any way in datastage to do reverse,i.e to denormalize the normalize data.
Thanks

Hi, I have a job which loads data from sequential file to target table(no intermediate stage in between and also no processing). My job gets aborted because of bad data(Character was coming in Interger field).In table I have set Transaction Size as 1 and bad data is suppose 50th record.My question i...

In our project we run sequences to load records everydy.we have scheduled sequences in Unix.I want to know is there any difference,if I schedule job using datasatage director or schedule using Unix.
Thanks

I am planning for DS certification,Can anybody guide me.
Thanks

1.In my job i have checked the lenngth and datatype of all input and output columns,both are in proper synchronization (for mismatch of datatype between source and target I have changed datatype using function).
2.I am not using any stagevariable in my job still it is giving problem.