DSXchange

use TimeStampToString(DSJOBTIMESTAMP,"%yyyy-%mm-%dd %hh:%nn:%ss") in the transformer, that would help Thats a px function and of no use in a server job. prmuttireddy, how d ... oops, I apologise for the mistake,Thanks to DSGuru for pointing that out for me under routines->sdk->Date there ...

Hi Ajit, Thanks for your reply.But i am not getting solution.In source generated query for Timestamp it has used as TO_CHAR(source fieldname, 'YYYY-MM-DD HH24:MI:SS'). But in this case how to keep the conversion for that default DSJOBTIMESTAMP value. Regards, Reddy. use TimeStampToString(DSJOBTIMES...

Why not try replace the IsNull()/IsNotNull() with a NullToEmpty like this - If (i/p_column1 = "A" AND trim(NullToEmpty(ip_column2))<>"") Then ip_column2[1,7] ELSE SetNull() Or if you want to use to IFs (not adviced) - If i/p_column1 = "A" Then (If trim(NullToEmpty(ip_c...

Hello, New to DS so would appreciate any help! I am looking at a join which has the following comment... "Performs cartesian product of the Facilty Expiry Date records with Time band codes". Does anyone have any idea what this means?! Thanks. Welcome aboard Newbie, Cartesian product is a ...

Thanks Ajith, But i am not still clear with when it should be turned on. Thanks In normal cases when you are sure about metadata you can keep it off. If you want to use RCP with certain stages (Sequential File,File Set ,External Source, External Target,Column Import, Column Export) RCP should be tu...

Hi, I have been using the following scenario. DRS stage(source)---->Trans Stage---->DRS stage(target) In Target table i have one filed as Maritus_DT and data type is Date.I have changed that filed data type to Timestamp.But that field not exists in the Source.so i have given the default value as &q...

Hi All :D , I have to do a validation on a Varchar field as follows.... 1) First Char must be Alpha---i got this using function Alpha(Left(inxfmLoadData1.DFSNAM,1)) = 1 2) Valid char.. r Alphabets,Blanks,Hypens and Apostrophes... 3) Blanks,Hypens and Apostrophes must not be adjacent Can anybody Hel...

Hi all, Could anyone please let me know all the stage in Enterprise Edition. Infact, I'm in doubt ------ Is there DRM/DRS/Dynamic RDBMS stage in Enterprise Edition??? Thanks and Regards, Satish There are about 52 stages in EE which includes Oracle Enterprise Stage, DB2/UDB Enterprise Stage,Teradata...

is this the problem with only one job or every job? , I am asking this because are you sure that your configuration file is working well. Because, It says Premature EOF on node tfukmhfirp1 No such file or directory can you check the Config file for that node and check everything is all right? I can ...

Hi All, I am loading the data in to Oracle9i table using PX. But before loading, I want to retrieve the maximum value of the Sl_No (a sequence number) in to a stage variable and then want to use that value for further to get the next serial number for the incoming source recordas there are some pri...

I used TrimLeadingandTrilig funcion,but warning is still comining can u post the transformation you are doing and the datatypes and lengths of inputs and outputs. More importantly, Check whether your conversion works, If everything is fine, just ignore the warnings, It signifies nothing then. If yo...

Hi ajith, Thank you very much!! For exporting this, do we need to be in the root or in DSEngine subfolder?? Can you please give me the steps involved for executing this 'dsjob' command? You dont have to be root, This is not a permanent solution too, It is just for that shell. you have to execute th...

Hi ajith, Do you mean that first i have to be in bin subfolder and execute the following?? ./dsjob -run -mode NORMAL ./etl/ascential/Ascential/DataStage/Projects/<project> ./etl/ascential/Ascential/DataStage/<jobname> I am getting ld.so.1: dsjob: fatal: libvmdsapi.so: open failed: No such file or d...

ajmore wrote:Hi...
I had applied the Trim function to the Col..previously only.. now also tried for TrimLeadingTrailing but again it is showing the same warnings...

Are you sure that your data is valid ...

Can u check the rows u are having a problem and find out whether the data is fine

Hi All :D , I am getting the following warning during conversion of a string(9) to decimal(9)....I am using StringToDecimal(colName) function in transformer Stage. :!: t3xfrmIIINQ0,2: Conversion error calling conversion routine decimal_from_string data may have been lost. Can anybody suggest a work...