DSXchange

Thanks for the reply. the first lookup is a hash lookup so it's simple. the second database lookup requires to pass the transformer values (source SQL query results being passed into the transformer, for example IO, Line) into the SQL. the lookup SQL would look like : select number from table where ...

is there anyone who was able to configure datastage to work with mySQL on Sun Solaris 2.8? We had such bad experience trying to get it to work and we haven't had any luck yet.

We are planning to upgrade 6.0.1 to 7.0.0. Has anyone already done it? Any major problems found? Any upgrade recommendations? We are running Sun Solaris 2.8.

I am working on a very common ETL task, but datastage seem not be able to do it. I have a SQL statement (query1) that returns two keys: IO and Line and two metrics. I piped the query results into a Transformer for another lookup based on the two keys. However, I need to do another lookup that's SQL ...

Anybody can help is highly appreciated. I used unix's cron to schedule dsjob to run every morning. however, sometimes the job may run for more than 24 hours. In that case, I will alwars get "Status code = -2 DSJE_BADSTATE" error. I am wondering how I can invoke multiple instances of the sa...

I have spent so much time, but couldn't get the sleep function to work. Would like to see any experts can provide some suggestions. Here is my problem: I have to check data sources and make sure all of them are available before proceeding with the rest of ETL. Currently my job wakes up everyday and ...

I am trying to decide if datastage is an efficient tool to parse the following text as opposed to doing it in Perl: |sessionID=acnielsen3-716-1-834|.q211=1|.q354=0|.q175=0|.q176=0|.q124=0| My file contains many of the above formatted rows. The number of pipes in one row is not fixed (dynamic). What ...