DSXchange

Hi All, I'm using the function @PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 to generate sequence number but in middle my job is skipping sequence numbers. from 1 to 156 its coming correctly but after 156 its an issue as below: 0000155 0000156 0000158 0000159 0000160 0000162 0000163 0000164...

Hi All, I have a requirement where i get values from my source file as: 13002 13020 13037 my o/p will be: 2013-01-02 2013-01-20 2013-02-06 which means from source, 1st 2 chars ie, 13 indicates 2013 and next 2 chars indicates date and month, say: 02 -> 2-Jan 20 -> 20-Jan 33 -> 6-Feb How can I achieve...

Sorry for delay in reply.

When i execute the sql query in SQL developer tool its working fine. But when i put the same sql query then PM/AM is getting disappeared..

Thanks in Advance,

Hi All, When i execute the below sql query in oracle database i get the following output: select FROM_TZ(CAST(TO_DATE(TO_CHAR(sysDate,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') AS TIMESTAMP), 'Europe/London') AT TIME ZONE 'GMT' from dual; output: 24-MAY-13 01.26.23.000000000 PM GMT When i run...

I'm using Datastage 8.1 version and i didnt find the function DateFromComponents().

Thanks,

Hi All,

My requirement says:

my output column should be 1 from Last sunday of March till last sunday of October and other times it will be 0.

How to do this logic in transformer?

Thanks in Advance,

Hi All, My source is coming from oracle database and my target is Fixed length sequential file. my source column col1 is varchar(60) and target column will be char(60). i'm getting NULL values from source and my job is aborting. In SEQ stage, under format tab i gave in NULL FIELD VALUE=' ' in Field ...

Thanks for all the replies. I will try this solution.

Hi All,

I need to perform sum(col1) group by col2 in oracle and that value i need to fetch as comma delimited like 99,999,999.

my source column col1 is decimal(22,5) and my target column is varchar2(10).

Is there any way to do this in transformer?

Thanks in Advance,

After using NullToZero function i'm not getting the warnings.

Thanks,

salarythousands is the original column im using till transformer and then doing calculations.

Problem is salarythousands is decimal datatype and im loading into varchar datatype column in transformer.

Also its using multinode configuration.

Thanks,

My reference ora stage contains a column salarythousands with decimal datatype Im performing left outer join of above reference ora stage with my source ora stage and passing field value to transformer. in transformer im doing calculation as: stagevariable1 with datatype decimal 11, stagevariable1 =...

Thanks All....

DateToString() function works but how can i convert the datatype of string to date as my target column in db is having date datatype .

I need to check on project default date format once because StringToDate() function is now working for me...


Thanks,

Hi All,

I used StringtoDate function in transformer stage as below:

StringToDate(Convert('-','',CurrentDate()),"%yyyy%mm%dd")

But in the target date still comes with yyyy-mm-dd format. Unable to understand the issue.

Thanks in Advance,

I'm using in job parameter the column p_dt which is of string datatype and value we pass through sequencer as "2013-04-04".

DT:date=date_from_string(#p_dt#,"yyyy-mm-dd")

Can't i pass it as job parameter?