DSXchange

sorry to post here in this way, but I need a help from Ray /Crig.. I purchsed premium mebership but its been two days over still its not activated... I sent mail to webmaster, membership.director@dsxchange.com and editor but has not recived any response yet. Can you please tell me the email id to co...

I had a similer issue and I used the following method to fix it.

I used an external file stage and pass the program as

cat /mydir/datafile* and defined my table defnition as I expect from the fiel and it worked.

In one of Rays post I saw Dataset is the best stage to use if I want to store data for a reference link and the data volume is huge. Then practically this lookup file set is designed to use at which place. Can anyone give me a scenario where this stage do the best fit. I am in to designing these day...

Precise!

Thanks mate. My understanding was wrong and its clear now.

Can anyone help tell me how to define a file set control file (.fs file). I simply created a fileset by giving the full path of a file I want to read, but got this error, cany anyone help. I am talking about normal fileset stage, not lookup fileset. File_Set_10: In file set "/etl_dev/bfp/PAAM/T...

I need a help to get my concept validated... I read many articles and I have a mixed understanding about partitioning and node. Q1. If I have 4 nodes configured in my config file. Any parallel job that running in my server will make exactly 4 copies of my job. Is that right? Q2. If I hash partitione...

Hi , I have values coming like this. My datatype is Decimal(5,2) 00023.0200 00035.20 I am using the following function and assing to a Varchar field. DecimalToString(MyVar,"suppress_zero") The issue is first value it fine..my result is 23.02 Second value is killing my peace, its coming lik...

I have a continously growing table. I have to perform an insert update. Please suggest me which is the best approach. 1. Do update in Job 1, Then do insert in Job 2 2. Select Upsert mode and do it in one job. Which is more efficient and faster? I am using Db2 stage. Will I face any perfomance hit by...

Reuesitng for a help. How can I identify the updates made to any of the jobs in my project? I know to identify the jobs deleted we can use the following command, Reuesting to get a similar one for update. SELECT INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD IS NOT NULL AND PREVDTD <> ''...

one last query... Datastage supported in windows server 2003 ?

chulett wrote:Install whichever compiler the docs say are supported. However, as noted previously, Vista is not supported and likely the cause of your socket errors. ...

Yes. My version is 7.5x2. So how can I make it work. which version of c++ i should installl?

chulett wrote:The C++ compiler only comes into play when you build a job with a transformer in it. What exact version of DataStage is this - 7.5x2? That's the only 7.x version with any hope of working but so ...

Ray..Sry I installed datatage knowingly that it may not support in windows vista. but gave a try.. but you know, if i create a server job its working with out any trouble... so i think the issue is c++ compiler. I did not install any c++ compiler, if it is possible for you, will you please tell me w...

I installed Datastage Px in my windows vista machine after a lot of struggle. But what's happening now is, server jobs running with out any issues but none of my parallel job running. I will tell you wht i am doing, if someone cal help, will be a great help to me. Step 1: Login to datastage designer...

sorry for asking a general question.. All of the suddun my jobs are suffering a slowness in exeuction.... 20 minutes gone to 2 hour..... Its a unix enviornment... the worst thing is the code is working absolutly fine in one server but no tin other.... unix team confirms its fine with unix server.......

Hi , Not sure am I asking a stupid question or not? Can anyone tell me how can I get the version of my datastage server? like 7.5.1 7.5.2 etc... I am using ds client and its version is 7.5.2. Can I safly assume that my server is also the same version. I have no hurry to get to know the answer.. if s...