DSXchange

For the record, the client is always on Windows. Is your server as well? And by 'different location' do you mean physically separated by a great distance? Or just two different local boxes? First question would be - did you search the forums for the 'failed to authenticate' message? It has been dis...

Hi,

server and client are at different location.

Client is on windows.
While tried to connect its throwing the following error

Failed to authenticate the current user against the selected Domain
Operation timed out: connect:could be due to invalid address

Please hekp me out

Thankyou

Hi, i have installed datastage client on my machine. (Server at another location) While accessing datstage designer its showing the following error. Failed to authenticate the current user against the selected Domain You are attempting to connect to server [****]. This server is configured to commun...

Hi Everybody, Hi have to develop a job where it has to satisfy the condition " if (year1<>Year2) or(Area1<>Area2) or (Region1<>Region2) then Populate a sequential file with with year2,Area2,Region2" Pls help me solving this issue. I have used joiner stage to join Both the files 1 and 2 as...

Hi Everybody, Hi have to develop a job where it has to satisfy the condition " if (year1<>Year2) or(Area1<>Area2) or (Region1<>Region2) then Populate a sequential file with with year2,Area2,Region2" Pls help me solving this issue. I have used joiner stage to join Both the files 1 and 2 as ...

sachin1 wrote:stage variable will help............

stage variable = stage variable + input column value

Hi Sachin,
Sorry i did not get u.For example if Quantity is a column then i want sum(Quantity) as a single value irrespective of the other columns.

Thanks

Hi All,

I am trying to sum a column without grouping.I need the summation as a single value so that i can use that as variable in calculation.Please help me out.

Thanks in advance.

Hi,
I want to implement round function in my job.i.e rounding decimals to integer values.EX:round(3.5)=4 ,round(3.2)=3,round(3.6)=4

I am using datstage 7.5 serverjobs.

Please let me know the logic to implement this function in datastage job.
I want to use this function in stagevariable.