DSXchange

Could you please tell me how huge is the data?

Hello Rakesh,

What is your start row field(Start Writing from this Row) in unstructured data set to?

Please also check whether it is writing to any part of the Excel sheet.

I am trying to read a COBOL file, But i am experiencing '{','}' signs in the data. My options are EBCDIC and Binary. But still seeing these values when i am trying to view the data in output tab. I looked at many post here on DSXCHANGE, but i could'nt figure out the exact answer, Appreciate if someo...

Its not supported Writing to the spreadsheets using the unstructured Data Stage in 9.1 version, You can always do that in 11.5 version, Where you have ability to write to a single or all the sheets in a workbook.

Stage Variable Doesn't work for Different SRC_LIN_ID,chulet i have searched enough regarding this topic, but no valid answer

A Small correction to my Question With this Data there is another additional field in the input i.e source_lin_ID,So the data is like this Src_lin_id,FSCL_YR,MTH_NUM,AMT 1,1997,1,20 1,1997,2,30 . . . 2,1997,1,30 2,1997,2,40 . . . . 3,1997,1,40 3,1997,2,50 . . . . So the key should be for the SRC_Lin...

Is there any way whether that can be accomplished in Oracle Source stage itself.

Thanks,
I checked that Logic, it works Good . Will this work for all the years and for all the line items.

Hello, My source is Oracle, And i have this columns in my source FSCL yr,MTH_NUM,AMT And my requirement is to calculate the YTD based on the month. So for example if i am in the month num 2, then the YTD should be AMT in Month1 +AMT in month2 If i am in Month 3 then the YTD should be AMT in Month1 +...

The source is Oracle DB not the file

I have a scenario where I have columns Like REV_ACT_JAN ........ REV_ACT_DEC, I am doing a pivot to store all the columns in one field i.e Amount, And also i have another filed MONTH which should be identified from the Column Name(ex:REV_ACT_JAN then the MONTH field should have 01 and so on) Could s...

Is there any way to load the Timestamp field from datastage into Oracle Date field.

yes not using datastage, Just to view or the contents of excel file on AIX server.

Hello,

Is there any way that i can view or read Excel file on AIX server using any commands or script. Is it possible?

Thanks
Deep

Its not possible at all?I see this works on version above 11.3,Can someone check it out for me.whether unstructured Data stage can be used as Output stage.