DSXchange

Hi- In past I've used CDC stage to do change data capture in PX at a table level but now I need to know how CDC could be implemented using server edition. Also, my requirement is to do CDC at the schema level, in other words I need to know what records have been inserted, updated or deleted from all...

Hi,
Can someone please help me understand when ABAP stage should be used to extract data vs. BAPI? What is the main difference between these 2 techniques? And when one is supposed to use the IDoc stage?

Thanks !!!

Thanks for your reply. But if data is sorted in the aggregator, is it sorted in memory or scratch disk? The Sort checkbox is your way of telling the aggregator stage that your incoming data is sorted. By providing this information to the aggregator stage you can cut down on the processing time withi...

Hello,
When we say sort the data in the aggregator or any other stage, where exactly it's done? Where the data resides being sort. Could anyone please explain this process? Is this same for Server and PX?

Thanks in advance.

Thank you chulett and Ray.

Hello,
I know that Parallel Extender is also known as PX or DataStage Enterprise edition is same as PX. But I would like to know does the DataStage XE represents the DataStage Mainframe i.e. DataStage 390?

Thanks !!

Thank you ray.wurlod and trokosz .

Hello, On the ascential site, when I was going through the future release, I came across Datastage version 8 information. I'm wondering is it PX version or Server ? If Server, I was under the impression that they are going to take out server from the market eventually. Then why the new version of Se...

In the sequencer, if one of the job had more than 5% of the data going on the reject link , how to stop sequencer without executing the next job?Can I use some job parameter or some thing in the trigger of the sequencer?

Hi, I've created a simple BuildOp for learning purpose . The i/p has 2 integer columns namely Arg1, Arg2 and o/p has got 3 columns, Arg1,Arg2 and Result. Result = Arg1+Arg2. I'm giving the input using Row generator. The job/BuildOp are getting compiled successfully but when I run the job , it's fini...

Hi, Can someone please let me know how to write the Where clause in the filter statement for following: 1. using wild card -- something similar like '%' in Oracle. For example my oracle where clause something like this: where city='A%' -- how in the where clause of filter 2. where city IS NULL-- how...

Hi, In one of my jobs, I'm using the Transformer for the NULL handling. The way I'm writing is: If trim(***)="" then "" else ***- The input metadata is Nullable but the output not. Now, I'm trying to do the same thing using modify stage with HANDLE_NULL(). If I make a statement l...

Hi, After every run of the job how to delete the.ds files and corresponding data from the scratch space? I came to know that the 7.5 does this automatically . Where should I look fot the documentation for the information related to this? Or can anybody explain how this has to be handled ? Thanks in ...

Hi , One of my job is getting aborted because it is throwing more than 50 warning messages. The strange thing I noticed is, if the job is run through the designer it doesn't aborts but with everything same if I run the same job with same data through the director it aborts because of more than 50 me...

Hi, In our project, we are using couple of "custom stages". when we did the import/export from the development to testing environment we found out that everything was getting compiled except this. We tried the import/export using .dsx as well as xml format , but the problem was persistent ...