DSXchange

Hi everyone ,


Thanks for the reply .i got the solution as i used real as datatype instead of varchar ,it worked

Is there anyway that we can use that logic in transformer like adding based on the group as i tried with aggregator for many times but its not working.

Thanks in advance

The datatype i have used for both input and output variables as Vchar.I havent used any decimal override on the outpu.

i first sorted and grouped based on sort and aggregator function.after that i used stage variables to compare with the previous and current record .but initially i asigned the row column as a constant variable.

Hi everyone, I have one more problem, I need to add one more field as row in my task and i have to get the row number based on the group i.e. If i have three columns say company code, product code, amt. I need to add another column for the rows. the output should come in this way. abc,coke,120,1 abc...

Hi Every one , 1. I used some stages to develop the job. I am having a problem with the aggregator stage as when i perform the function 'Sum' in aggregator stage, I am getting an error saying that invalid argument type. When I use with any other functions in aggregator stage, it is working. The proc...

Hi every one,

Can anyone tell me the process of implementing scdtype1 and scdtype2 using Surrogate key.

Thanks in advance

Hi everyone , can u guys please help me out to know the advantages of using datastage rather than mainframe.we are planning to build an application using datastage and some part of the application is already available in mainframe on cobol programs.so my boss is pointing out of why to use datastage ...

@vivekgadwal Yes, you made a good point but all you explained is to move from version to version like 7.5 to 8.x. Which is straight forward with some traps. But in this case He is trying to move from server to parallel, which is a lenghty and complex task, IBM does have tool to convert it but that ...

There is no Direct mechanism to Migrate datastge code form server edition to Enterprise edition, need to use some intermediate tools like dotnet to migrate code and also not sure which will give hundred percent results just half part only it will do remaining things will be done manually Thankx for...

Hi Guys , Can U plzz tel me in detail how to migrate the jobs from DS 7.5.2 Server edition to DS 8.1 Parallel edition as i am new to datastage and my task is to do migration.If u can explain me in detail That will be a great help. Thanks I don't know that U could do that. U is only a developer; he ...

Hi Guys ,

Can U plzz tel me in detail how to migrate the jobs from DS 7.5.2 Server edition to DS 8.1 Parallel edition as i am new to datastage and my task is to do migration.If u can explain me in detail That will be a great help.

Thanks