DSXchange

I want to convert the date format dd-mm-yyyy to mm-dd-yy in transformer stage, but it only displaying in yyyy-mm-dd. (I read the source date format as char from sequential file stage and now i am using StringToDate function to convert into mm-dd-yy. I am getting yyy-mm-dd only it targer and it also...

rajendharreddy wrote:sorry, When I submit CHAR 8 is getting replaced

Hi,

U can use the convert in the transformer to remove the unwanted line

Convert('-','', inputcolumn)

i have replaced the '-' by null space ('')

Regards
Naveen.K

Hi, any way i am just hadding little bit flavour to niranjansigeni post create stage variables 1.In that stage variables properties change the datatype as date 2.And the output column should be the date StringToDate(IP.ED_DATE,"%yyyy-%mm-%dd")-- sv piont sv to output column in that Derivat...

What is the use of process control table in job sequence?? hi, There will be control table in the database.. and when u make any jobs into sequencer it will just put an entry on the control table in simple words u can tell that it is used for Audit Purpose.. job flow will as follows job->mini seque...

What is the use of process control table in job sequence?? hi, There will be control table in the database.. and when u make any jobs into sequencer it will just put an entry on the control table in simple words u can tell that it is used for Audit Purpose.. job flow will as follows job->mini seque...

Have you though about just using 3 Oracle Enterprise stages and linking the 3 streams using a funnel stage? ... Hi ArndW, Here I am giving the clear picture we are using oracle database as source. There are three tables like this.. 1 .Invoice_Details- INVOICE_NO NOT NULL VARCHAR2(10) INVOICE_DATE D...