DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 146 matches
Author Message
 Topic: Web Service Invocation from SOAPUI
Raghavendra

Replies: 4
Views: 4688

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Wed May 25, 2011 12:25 am   Subject: Web Service Invocation from SOAPUI
eostic,

Than you for your inputs. My userid got locked so couldn't reply to your message. I created a new userid for premium membership.

We have asked the consumers to flatten the xml structure ...
 Topic: Web Service Invocation from SOAPUI
Raghavendra

Replies: 4
Views: 4688

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Thu Apr 28, 2011 8:41 am   Subject: Web Service Invocation from SOAPUI
DataStage® Release: 8x
Job Type: Server
OS: Unix
We have a created a Name Search Job in QualityStage and exposed it as a web service. Our idea here is that this should be consumed by multiple applications.

We have defined a CMM standard xml respo ...
 Topic: Customer Name Matching
Raghavendra

Replies: 0
Views: 1058

PostForum: IBM QualityStage   Posted: Wed Mar 23, 2011 4:00 am   Subject: Customer Name Matching
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
We have a requirement to search a database for a customer based on Name and Address fields. The search happens in real time from a web service.

We have customer database with 10 million rows (Name ...
 Topic: How to use dsexport.exe in batch without export status box?
Raghavendra

Replies: 4
Views: 7129

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 30, 2008 1:47 am   Subject: How to use dsexport.exe in batch without export status box?
You can export the whole project as a single dsx file and then run some scripts to parse the file and create one dsx file per job.

For more information refer the following link

http://www.dsxcha ...
Resolved
 Topic: datastage job compilation
Raghavendra

Replies: 7
Views: 5537

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 30, 2008 1:37 am   Subject: datastage job compilation
I believe we cannot compile a job in through the command prompt.
 Topic: how to assign next value to the current record
Raghavendra

Replies: 2
Views: 1095

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 30, 2008 1:30 am   Subject: how to assign next value to the current record
First sort the data then using a copystage send the rows to two links.

On the first link add a new column (KEY) with generated numbers from 1.
On the second link add another column(KEY) with gener ...
 Topic: Combine multiple rows into one row (Vertical Pivoting)
Raghavendra

Replies: 10
Views: 12232

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Dec 12, 2008 6:53 am   Subject: Combine multiple rows into one row (Vertical Pivoting)
In this example I see you have a set of 5 records. In your data, is this set of records fixed.
 Topic: Write 0 to sequential file when source DB return 0 records
Raghavendra

Replies: 4
Views: 1479

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri May 02, 2008 12:39 am   Subject: Write 0 to sequential file when source DB return 0 records
I have implemented the same kind of logic in server using db2.

I have fired a query using Count(Primary key) first and checked if it is 0 or more. If it is 0, write 0 in the sequential file directl ...
 Topic: Target file in different location when there is a reject.
Raghavendra

Replies: 1
Views: 879

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 27, 2008 12:51 am   Subject: Target file in different location when there is a reject.
In After Job sub-routine write a script to check if there is a reject record.If you find reject record then move the file to the required location.
 Topic: Performance issue
Raghavendra

Replies: 4
Views: 1568

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 27, 2008 12:44 am   Subject: Performance issue
I belive in latest versions (7.5V onwards) transformer is not a performance overhead.
 Topic: Getting error while doing lookup using lookup stage.
Raghavendra

Replies: 2
Views: 1375

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 27, 2008 12:37 am   Subject: Getting error while doing lookup using lookup stage.
Is your file name ends with ".v"
 Topic: Compare the number of records
Raghavendra

Replies: 5
Views: 1667

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 26, 2008 3:39 am   Subject: Compare the number of records
Can you please let me know what is CART input file & Control file?
Is CART some different file type?
 Topic: Sorting, Partitoning
Raghavendra

Replies: 3
Views: 1093

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 12, 2008 12:54 am   Subject: Sorting, Partitoning
I will prefer to set the partition to same in the sort stage for this scenario.
 Topic: Pivoting
Raghavendra

Replies: 2
Views: 932

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 12, 2008 12:39 am   Subject: Pivoting
Do you what is the maximum number of rows that has to be converted into columns?
 Topic: Regarding surrogate key
Raghavendra

Replies: 6
Views: 1848

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Mar 04, 2008 11:17 pm   Subject: Regarding surrogate key
How are you going to maintain the history in the database? Which type of SCD you are using? IS it type 1 or 2 or 3.

If you want to generate the surrogate key how would you like to generate. Do you ...
 

 Jump to:   



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