DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 58 matches
Author Message
 Topic: Oracle connector - Deadlock issue
anudeepdasari001

Replies: 9
Views: 1075

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 14, 2019 3:33 am   Subject: Oracle connector - Deadlock issue
Could you please tell me how huge is the data?
 Topic: Issue with Unstructured data stage
anudeepdasari001

Replies: 3
Views: 707

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 11, 2019 9:39 am   Subject: Issue with Unstructured data stage
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.
 Topic: COBOL File Issues
anudeepdasari001

Replies: 3
Views: 977

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 11, 2018 7:40 am   Subject: COBOL File Issues
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: CFF File reading Cobol file
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 ...
 Topic: Reading and writing data into csv files?
anudeepdasari001

Replies: 14
Views: 4500

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 07, 2017 6:24 am   Subject: Reading and writing data into csv files?
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 ...
 Topic: YTD BASED ON THE MONTH NUMBER
anudeepdasari001

Replies: 7
Views: 2812

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 30, 2017 11:16 am   Subject: YTD BASED ON THE MONTH NUMBER
Stage Variable Doesn't work for Different SRC_LIN_ID,chulet i have searched enough regarding this topic, but no valid answer
 Topic: YTD BASED ON THE MONTH NUMBER
anudeepdasari001

Replies: 7
Views: 2812

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 30, 2017 7:31 am   Subject: YTD BASED ON THE MONTH NUMBER
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 ...
 Topic: YTD BASED ON THE MONTH NUMBER
anudeepdasari001

Replies: 7
Views: 2812

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 30, 2017 7:23 am   Subject: YTD BASED ON THE MONTH NUMBER
Is there any way whether that can be accomplished in Oracle Source stage itself.
 Topic: YTD BASED ON THE MONTH NUMBER
anudeepdasari001

Replies: 7
Views: 2812

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 30, 2017 7:20 am   Subject: YTD BASED ON THE MONTH NUMBER
Thanks,
I checked that Logic, it works Good . Will this work for all the years and for all the line items.
 Topic: YTD BASED ON THE MONTH NUMBER
anudeepdasari001

Replies: 7
Views: 2812

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 30, 2017 6:35 am   Subject: YTD BASED ON THE MONTH NUMBER
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Getting Month Name from Column Name
anudeepdasari001

Replies: 4
Views: 2326

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 25, 2017 1:11 pm   Subject: Getting Month Name from Column Name
The source is Oracle DB not the file
 Topic: Getting Month Name from Column Name
anudeepdasari001

Replies: 4
Views: 2326

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 24, 2017 8:57 am   Subject: Getting Month Name from Column Name
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 i ...
 Topic: Datastage Timestamp field into Oracle Date field
anudeepdasari001

Replies: 1
Views: 1207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 26, 2017 8:47 am   Subject: Datastage Timestamp field into Oracle Date field
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Is there any way to load the Timestamp field from datastage into Oracle Date field.
 Topic: Reading Excel on AIX server
anudeepdasari001

Replies: 3
Views: 1456

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 17, 2017 9:49 am   Subject: Reading Excel on AIX server
yes not using datastage, Just to view or the contents of excel file on AIX server.
 Topic: Reading Excel on AIX server
anudeepdasari001

Replies: 3
Views: 1456

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 17, 2017 9:29 am   Subject: Reading Excel on AIX server
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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
 Topic: Writing to Excel Using unstructured Data Stage
anudeepdasari001

Replies: 5
Views: 1876

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 11, 2017 7:10 am   Subject: Writing to Excel Using unstructured Data Stage
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.
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours