DSXchange

Hi All, I need some ideas for Unit testing our jobs. Basically, the job would have rules like this. 1) Read all the records from source - If Column A = 'X' Then If Column C = 2, derive A= 23 Else If Column C = 3, derive A= 28 Else If Column C = 6, derive A= 28 Else If Column C = 9, derive A by perfo...

Premium membership expired

Actually, the way, i would have to identify multiple errors would be in the same variable. Eg: If a record is going through multiple lookups, i check for the derived values which is null in the transformer in the same variable and am populating it.

Hi All, Am trying to concatenate a error description column, based on key column. Say my data is like this. ID, Number, Error Code 100, MD350, Invalid Amount 101, MD310, Invalid Account 102, MD350, Invalid Code 103, MD400, Invalid Transaction 104, MD350, Invalid Code I wanted combine the error code ...

All, I am trying to do the below sql thing in Datastage(transformer). I read my source Amount column as Char(16) though the format of the value is (Decimal 15,2). The same column is used to populate both these target columns. CAST(ABS(CAST(PREMIUM_WRITTEN_AMT as DECIMAL(15,2))*100) as DECIMAL(15,0))...

Oh, yes. Got it. Thanks!

Hi Spemma,

Can the input data be split into two? first nine rows and rest all.

Add a 'Dummy' column with constant value, to the first part and 'Dummy' column with the same value in the second part and join the two..

Someone can suggest on how to get all the rows to one column (pivoting stuff) ..

Many thanks Craig and ArdnW.

Here is the command line syntax i used from the client machine. cd C:\IBM\InformationServer\Clients\Classic\ director.exe /H=XXXX20:9080 /U=xxxx /P=xxxxx Not showing any errors. But it is just opening the director tool and waiting for my inputs which i dont want. I want to see everything in CLI. I a...

@Craig: I am not able to make any transaction through it. It says my account is limited. Money gets deducted from my card and doesn't gets credited to DSXchange. Frustrating! I've contacted Rick, Dennis too on this.. They are not able to process my order too.. :( @ Ramesh : Yeah, you are right. I am...

Hi !

I am trying for 2 months now to get the membership of dsxchange. There are lots of problem with paypal. Is there any other way to make the transaction and get the membership ??

Thanks,
Meenakshi

Any of you guys have the following s/ws, Microsoft Visual C++ .Net 2003 # Microsoft Visual Studio 2005 Professional Edition C++ # Microsoft Visual Studio .NET 2005 Express Edition C++ # Microsoft Visual Studio 2008 Professional Edition C++ # Microsoft Visual Studio .NET 2008 Express Edition C+ This ...

Hi,

My premium membership is not yet activated and it 4 business days now. Money got deducted from my accountant. When will it get activated?

-Meenakshi

Yes, parallel routines.

Waiting for my premium membership to get activated..

You can have two sequential files. One reading the first four columns with the key column and other file with key column and the fifth column and join them with the key column.

ray.wurlod wrote:Any time soon - though it IS the weekend.

Thanks! I knew it is weekend. I just wanted to know the time, since I didn't get any info on how many business days it would take.