DSXchange

Guys, Any one tried to connect DataStage server to mutiple Oracle databases like 9i and 10g simultaneously? I know we can connect from DataStage server to only one oracle SID at any given time( can connect to two databases placed under single instance). Any work around tried by others?

Sree

Are we sure, we can use MQ series stage in both server jobs and PX jobs? I am still waiting for access previleges in cleint site.

Sre

My main question is this.... Do I need to buy SOA to use MQ series? Can I manage MQ series with EE edition....? I have no plan to expose my DS jobs as webservices. As long as I can read messages from queue and write messages to queue is fine for me. I don't need exact realtime. for eaxmple Get custo...

Guys, I stuck with this situation. Before I goto Ascential, I thought to stop by here. My current client has DataStage EE 7.5.1.A license. We are looking to add funtionality to our application to update DB tables by receiving messages from MQ series based queues. We have EE license, Not SOA license....

You need to develop job with parameter to store file name ( assuming you know file anme before you read that). Use transformer stage to map the parmater name to field that mapped again to DB filedname. So each row will carry its file name along with data. That is the standard solution for this probl...

Use sort stage with Hash method and set "Create Key Change Column" property to true. So that first row will get this new column value as 1 and duplicates as 0. Then, Use switch or filter stage to fileter rows with 1 and 0. Is is simple way and shows better performance also. I used that. Sr...

You can use DB2 UDB API as a source and DB2 API or DB2 UDB Load as target.(DS server <-> DB2 UDB) In case of DB2 mainframe, you always point to DB2 connect server where it is loaded. That DB2 connect software will point you to DB2 mainframe. ( DS Server <-> Db2connect <-> DB2 mainframe). Hi All, I h...

Ray,
I don't beleive even those time lines he mentioned to me. I consider those dates as "min imum time lines". I beleive those time lines definitely moves forward ....... :D

Sree

ray.wurlod wrote:Do you believe everything sales people tell you?

I heard from IBM sales guy regarding that. As per my understanding, It might be Q4, 2006 or by early 2007. Beta testing almost all done as per his understanding. Only few clients signed up for Beta testing.

Sree

ray.wurlod wrote:Yes, I meant to say a full-time webmaster.

I know, some of the questions not described clearly, especially in "Data Transformation" etc. It took 3 to 4 mins to figure it out " what IBM is asking??" :roll: I guess they are part of testing sample questions. I don't think I did all of them right. Certification is just a show...

Hi Guys,

I got certified with 94% score.

Sree

Hi Guys, I got certified with 94% score.

Sree

Hi Guys, I got certified on weekend with 94% score.

Sree

gud morning everyone, I want to add a dataset having only one row and one column having the max surrogate key from previous stage to the incoming data which is not having this column plus millions of rows. Moreover i have to use this value a the initial value in the surrogate key stage. help me out...

Hi Is it possible wherein we can change the job parameter based upon each of the input record. To be more specific i have scenario wherein i want to do join of input A with input B. For each record in the input A i need to fire specific query to fetch records for B, which i will then be use for joi...