DSXchange

Thanks a lot. So bitwise op can be done with BASIC, but for parallel, we have to use C to manipulate it, even it's hard. I just wonder why bitwise logic op is not provided as a stardard ligocal op. It's easy to do so.

Thanks,

Hi there,

Does Datastage provide bitwise op? Can you get the highest 2 bits of a byte and then 4 bits, then the lowest 2 bits? I.e., a byte data is split to three parts: highest 2 bits, middle 4 bits, lowest 2 bits with Datastage?

Thanks,

Also, this warning is caused by a preceeding stage having the "Preserve Partitioning" flag set to "Propagate". This is the default value, and tells PX that it should attempt to maintain a partitioning method. Obviously the sequential stage can't preserve the partitioning. If thi...

Even they are the same customer, they are from different service providers, so it's a different account, you can not remove them. Business needs both of them in the system.

Thanks, Eric, for your good suggestion. But only database table look up can be configured with sparse look up as statement below. For look up into sequential file, there is no sparse look up possible. Thanks, Configuring sparse lookup operations Data that is read by a database stage can serve as ref...

This is not a case for server job or enterprise job. It's problem how enterprise edition can handle it. Such as for surrogate key case: you generate a surrogate key for a new customer. In the same run, the new customer can be present in more than one service providers, so can have more than one inst...

what is meant by with 12 writes? The job writes to 12 filesets with the same control file pathname and setting. This job tries to test whether fileset has the capacity of supporting multiple writes in one job or from different jobs like hash file in server edition. It seems fileset does not have the...

Yes, both have the following config file:

ParmSet_Common.$APT_CONFIG_FILE = .../Configurations/default.apt (From value file)

A fileset is created by a parallel job with 12 writes running in 2 nodes, so 24 files are created. When another job reads from the same fileset, it does not read all 24 files, instead it seems it just reads one of them. Both write and read jobs have the same pathname of the control file for the file...

I know what's wrong in the data. That's not the issue here. The issue here is that this response is not outputed. What's the criteria for the web service stage outputing error responses?

Thanks,

All messages are logged in the job log, but it's not outputed. such as below is logged in the job log, but is not outputed in Output link. Thanks, Server:xx Project:xx Job No:574 Job name:jb_call_services Invocation:group1 Event Number:73712 Event type:Info User:xx Timestamp:09-Apr-2014 3:52:00 PM M...

Hi there, Can you point out where I can find the message about web service stage output resonpse from a web service? I have a job with web service stage invoking Oracle Siebel web service with xml records. Sometimes the web service stage outputs responses with the data issue, sometimes doesn't. It o...

Datastage 8.7 is coded in Java so its response to mouse clicks or keys type in is very slow, just as a very old senior, which almost can not move. You can see Not Responding all the time at its title Pane. You need have a great patience to use this very very slow software. Like this is not slow enou...

Does anyone know that in order for SCD stage to work, both surrogate key and business key have to be in the target table? And you have to use surrogate key to track history for type 2. You can not use others, such as, start date to track history. The SCD stage can not handle tracking history by usin...

Does anyone know that in order for SCD stage to work, both surrogate key and business key have to be in the target table? And you have to use surrogate key to track history for type 2. You can not use others, such as, start date to track history. The SCD stage can not handle tracking history by usin...