DSXchange

RAY, there are just rows and coloums with out comma, or any other delimiters ,even they are not fixed-width format.

how to read a sequential file with out delimiters.

Thank's to all of you.

Hi ,

Source coloums in sequential file : A,B,C
Target coloums in table in oracle database:A,B,C,D,E

How to load this source file in to target table,
the coloums D,E in target table should be empty after loading.

Define a 'working day' for us. Does it include company holidays? If so, you'll need some kind of 'date dimension' like lookup, be it a warehouse table or spreasheet dumped to a csv. ... for example:02/15/2010 to 02/21/2010 are week days 02/17/2010 is holiday 02/20/2010 and 02/21/2010 are saturday a...

please help me in finding number of working days in a week syntax.

thanks in advance.

TO_DATE( '01-07-' || TO_CHAR(PS_D_DAY.YEAR_NUM - 1), 'DD-MM-YYYY' )



help me ,what code should write in transformer stage.

Hi friends----------- Help in finding the last_day of the month form a time stamp in a datastage.( here take the help of this code). [/CASE WHEN PS_D_DAY.MONTH_YR_NUM BETWEEN 1 AND 3 THEN PS_D_DAY.DAY_YR_NUM WHEN PS_D_DAY.MONTH_YR_NUM BETWEEN 4 AND 6 THEN PS_D_DAY.DAY_DT - TO_DATE( '01-04-' || TO_CH...

yes u can truncate the spaces or any other operation if u want to do you can but the whole information should be placed in the taget

can any one say the steps how to extract the data from oracle enterprise stage?

The source field consists of 80 characters , and I need to place this whole information in target field which consists of 40 characters in size .......
what transformation or what stages do I need to use?

thank you.

thankx for your response

just i want documentation of the parallel job stages with some examples ,if possible labs to practice..no problem if if it ascential datastage or ibm infosphere 8.0.1v

i appreciate for your healp
thanku again.

can you please suggest me the links for documents,so that i can get some knowledge before douing practice on tool.

sir, i am sorry about my english, if you really want to help me ,please help me by sending the datastage tutorials. happy thanks giving day in advance. I would recommend that you learn when SMS-style abbreviations are appropriate and when they are not. Here, they are not. A little more care with the...

hi
can u plz send me the tutorials ,iam new to datastage look for a job so, they are really help ful for me.
my id:vikramkola@yahoo.com
thanku