DSXchange

Hi, I am working on DS 7.5 EE on soalris I am runing five jobs in sequence in a sequence job. After running four jobs ,my fifth job aborted.when i restart my sequence i dont want to run all the four jobs which were executed sucessfully the sequence should run the 5 job. I tried check point option bu...

Hi,

I want to read data from a word document and load to target.

How can i achieve this( reading from a word document (.doc) file).

I am working on DS 7.5 EE

I am working on DS EE 7.5 I have to read 2 GB of data from a fact table and apply some agrregations and load to target. Is it better to do aggregations while reading from the oracle table itself using a userdefined query or to read all data in to DataStage and then use an agrregator for doing the sa...

[quote="ArndW"]srekant, use the platform you already have the hardware for. If you don't already have the hardware then there is no recommendation possible, there are too many variables. I can think of at least 20 factors off the top of my head without even trying.[/quote 1)Is it possible ...

comparision of DataStage 7.5.1A EE on win2003 and HP-UX nepa B.11.11.
which one is better to use if so why

we are using parameters can u guide on how to get this into a transformer.
using cut command in unix i am able to seperate the date part from file name and direct it to another file.

Hai I have a scenario where i have to strip of date part from the file name Ex: Input method_yyyymmdd.csv Output yyymmdd and want to use it as a default value for one of the column in my target. Any ideas how to achieve this.

HI, We had a new installation of DS 7.5 EE on Solaris 9.Everything is working fine.But when i am working on a job which contain oracle stage the following error is displayed main_program: Error loading "orchoracle": Could not find "orchoracle" on the library search path defined b...

Parallel job throwing compilation error at transformer stage.

Error Log(Captured by hitting More button in complie window):

Hi, I am working on DS 7.5 EE .Today when i tried to compile a job it is giving the following error "Output from transformer compilation follows: Cannot open file compile.tmp (Ld_JobName_PxJob.Xfm)" This job is compiled and working fine .can u help me on this. Not only this even in CFF sta...

HI, We are using CFF stage in DS EE7.5 .previously CFF is working fine and we are able to view data but today it is giving error when we try to view data.Error is "Erro1-Executing View data command" and "No rows were returned form the view data server command" we are able to view...

Hi,
I have a scenario where i am loading 10 million records from a flatfile to oracle table.After loading 6 million records job got aborted.My commit interval is 1000.Is it possible to load the records from the last run committed records instead of again starting from the first record.

Does this happen every time reliably, or intermittently? Do you ever achieve fully successful loads? Do the 200 rows actually make it into BW? Check for permissions and available disk space where the directory for BW load files exists. Have your network administrator check for unexpected dropouts o...

HI, I am facing the following problem . working on DataStage7.5 EE using SAP BW Load PAck to load data to BW.But when i run the job in DataStage log it is showing 200 records sent to Bw .But in BW side it is giving "No Data LOaded connection broken". Sometimes it is giving problem Infosour...

Srekant, think about what Ray and the DS job are telling you: the file has 1146600 bytes and a fixed width of 716. This is not correct; since the filesize is not a multiple of 716. Because this is wrong, DS cannot partition the reading of this file across processes. Look at the same file format whi...