DSXchange

Hi All,

Whenever I open a job I get the warning message as Getting User Role.

Could anyone help us on how to overcome this warning message? Is it something to do with the Installation problems?

Thanks in advance.

Spendem

Hi All,

Version Control is also a client component,
Hi Ray,
How do we differentiate the Compile time architecture and run time architecture?
Can you please throw some more light on his topic .

Many Thanks,
Spendem

Thanks DSguru,

I tried ftping it thru command prompt It didnt worked, The problem was I dont have access to that particular directory when we changed the access permissions for that directory we I was able to FTP the file.


Regards,
Spendem

Hi All, I am getting following error message when I m tryi ng to FTP to another server. Warning: FTPServer..FTP_Plug_in_1: 553 MicroReins.DAT: The file access permissions do not allow the specified action. Fatal: FTPServer..FTP_Plug_in_1: Error while trying to open connection for sending data to the...

Hi Ray, Thanks for your answer It worked out for the warning message but I am getting a new warning message as : Agg1: When checking operator: When binding output interface field "IMTRANSA_CLAIM" to field "IMTRANSA_CLAIM": Converting nullable source to non-nullable result; fatal ...

Hi All, I am getting a warning message with Aggregator stage for the Input field Decimal(15,3) when It is populated to output field Decimal(21,2) after the summation. The warning message is: Agg1: When checking operator: When binding output interface field "IMTRANSA_CLAIM" to field "I...

Hi,

Thanks for the answers,
Mandiyil what is ? I tried using it I am getting a validation error.

Ray,
If I m using BigInt or Integer(64) The preecing zeros seems to dissapear for Numeric field.

Is there any other round?

Many Thanks,
Sandeep

Hi All, I want to remove the leading "." i.e dot in the decimal value. Example: Input is date(10) = 2005-05-18 after coverting the date to decimal Output is Decimal(8) = 20050518. My requirement is to get Decimal(8) = 20050518 i.e I want to skip the . (dot) value. I tried using trim functi...

Hi,
Its working..... What I did is I converetd the dates to DateTostring in the stage variables
And then I used them at the derivation(Transformer Stage) as,
If AsInteger(Date1) = AsInteger(Date2) Then X Else Y.

Cheers,
Spendem

Hi,
Can we achieve this comparison 2006-05-17 = 2006-05-17 in the transformer stage?
If yes then can you please explain? since I when tried using it, the derivation was invalid.

Many Thanks,
Sandeep S Pendem

Hi, Thanks for your answer, Actually I am not populating the date column in the target I will be using the Incoming date from a feed file and need to compare it with the currentDate() of the system if both are same then I need to populate a different column based on this condition. Since date column...

Hi All, I want tp covert a date value to an integer values and want to make a comparison with the currentdate(). Ex: IncomingDate = 2006-05-12 CurrentDate() = 2006-05-17 Requirement is: If IncomingDate = CurrentDate() Then X Else Y I need to use above derivation on a tarnsaformer stage. Can anyone h...

Hi, Thanks for your response, I am using FTP plugin and in the properties option I left the space between column has blank and column delimeter as , The input file has only one single column of fixed width length 250 and when I m trying to ftp the same file using parallel job I am not able to ftp th...

Hi All, What is difference for the sequential file used in server edition and parallel edition? Since when I m FTP ing a sequential file from parallel job I could ftp the data before the space character appears i.e the data after the space charaters is not getting ftpied, and wherein the same file i...

Hi Ray/Arnd, Thanks for your answers The problem I am facing is The Incoming data has some blank values in it and the file is fixed width file of varchar(500). The data from the source looks lik somewhat: 1#HDR 0000 2#RSAP0020032102CLAIM0000001 00000032 2#RSAP0020032102 00000032 The O/p I m getting ...