DSXchange

Hey all you DataStage fans and users.... It has been years and years since I have been here. I haven't used Datastage in a long time now. But I have a bit of a treat for you all today!!! Many of you will not know the grand daddy of DataStage was Metaphor. Metaphor was a company that Ralph Kimball co...

Hi All, this is probably the best place for this post. Anyone who has joined over the last 7 years probably does not know me. I used to be the PSM for Ardent in Australia in the late 90s. I have been an independent consultant wandering around Europe and places further afield for the last 11 years. I...

ray.wurlod wrote:Can you ask the technical dude and let us know? That way your pioneering efforts won't be wasted!

Hi Ray,
I shall ask...

I haven't checked out the job sites in a while but a search of the Australian job site seek showed 110 DataStage jobs! I am used to seeing up to 20 jobs at any one time. Informatica had 49 job listings. There is a lot of duplication of listings on these sites and I figure if you divide it by three ...

Troy, you can get a lot more information from the Ralphs latest book on the ETL toolkit. Unfortunately and general ETL discussion is, by necessity, not tool specific. Also, if you check out my company web site www.instantbi.com you will see we have released a 'mapping spreadsheet' that will help you...

just in case it helps...we found the problem...even though I put the analysis server and message switch onto my laptop and called it the same names as the one we copied it from it still does not work. One of our guys managed to figure out that he had to make some changes inside the database and put ...

Hi All, I guess this is hoping against hope as there seems to be almost no-one on this forum....but PS on my laptop is going non-responsive. Just hangs. I've tried everything that makes any sense at all and a few things that do not.... I've had the full PS on my laptop, as well as connecting to a se...

Hi All, seems a very quiet forum. Anyway, in case it helps anyone else...we had a problem with PS and text files > 2GB on windows. It looks like the text ODBC driver that comes with it gets confused and delivers duplicate rows PS to profile....not much use really.... Ascential/IBM, you might want to...

Hi All, I am working for an Ascential Reseller and we have sold PStage. We have run a whole series of analysis work for the client on a machine at the client. However, I'd like to be able to copy the PStage database to my laptop and review the analysis done back at the hotel. (All comments related ...

Hi All, I am working for an Ascential Reseller and we have sold PStage. We have run a whole series of analysis work for the client on a machine at the client. However, I'd like to be able to copy the PStage database to my laptop and review the analysis done back at the hotel. (All comments related t...

Hi guys, we have code tables which have things like code, sdesc, ldesc. If course, for each row each field is unique and in the column analysis the 'all distinct values' and 'unique' boxes are ticked in the value side and the 'chosen' side. I've been asked whether we should uncheck the tick boxes on...

Luk wrote:Hi!
DS is trying to retrive information abouty tables through ODBC and it stops without any error massage.

But I have already fix it , I used libdbodbc9_n.so driver instead of libdbodbc9.so driver and ODBC is working fine !!

LUK

And the _n driver is????

sir, i am trying to import informatica mappings to datastage. in between while exporting from informatica to xml format i encounterd powrmart.dtd error due to which i couldnt get the xml page. i tried to open it in wordpad. how can i manuaaly convert the informatica xml format to datastage format. ...

I like to use stage variables and I will implement it and let you guys know... All are of great help. Thank's everyone in person... I heard that informatica has a built in module for handelling incremental aggregations. So any built-in stage in DS? Hi kommven, yes, INFA and DS both have 'built in m...

Hi! Did someone try to connect to sybase IQ 12.6 using ODBC or Sybase Openclient ang get Table definition in Unix!! I was using sybase IQ 12.5 and everything was OK but with IQ 12.6 I can't do this. LUK Hi Luk, you might be out on the leading edge there a bit 12.6 is pretty new...I put an append up...