DSXchange

[:(]
You lucky lucky people.
DataStage on Unix (sigh)
[V]

Mihai

_________________________
desk direct:+441908448571

Hi As Vincent said, there is are no specific things in DataStage that will help you build/manage slowly changing dimensions. On the surface, this may sound like a bad thing (i.e. no 'out of the box SCD', like ActaWorks/Informatica provide). In practice, it's actually a good thing. In my limited expe...

quote: Originally posted by ASP [br]Hi, This is the exact error : [datastage][sql client] [odbc] [data direct][odbc driver] [20101] ora 03113 - [end of file on communication channel] ASP I'm sorry to point out the obvious, but this looks like it's an Oracle SQL*NET error rather than something DataSt...

Hello I am assuming that the DataStage user community doesn't do anything nasty with the clients (e.g. power down machines, sever network connection) while logged in to DataStage :-) For expediency, I'll try to answer your questions in order: quote: What are these FIN_WAIT1, FIN_WAIT2, CLOSE_WAIT st...

You may need to check whether the scheduled runs are supposed to run as a particular user. You do this from the DataStage Administrator, Project Propreties, Scheduled Runs tab. By default, this is left blank (so everything runs as the system scheduler). If a particular value for the username&pas...

Hip Hip HuRay! [:D]

I was only able to connect 4 telnet users at once - uvlictool confirmed this. Thank you.

Kind regards,
Mihai

P.S. The DS version was 4.2.1r8

_________________
desk: 01908448571

Hmm.. depends on the definition of 'license limit'. We have a license of 1 developer and 64 run-time (Director) sessions. Anyway, it is possible to connect using the DS Client tools (e.g. Administrator/Director), so I can't nail it down to that. What I omitted to mention is that the message appears ...

Hello Over the last couple of days, we've been getting the message "UniVerse user limit reached. Please try again later" when there are 13 or more users declared by LISTU. We use the UniVerse engine a lot in our DataStage work. Could somebody tell us where this user limit comes from, and w...

quote: Originally posted by vmcburney Does Ascential charge for the number of processors on a server? If so what happens when you try to load a 4 processor license onto an 8 processor machine. No. Ascential licenses the number of developers. The hardware infrastructure plays no part in this. Kind re...

What trobinson said or @OUTROWLINK

Hi Luca Looking at your code, nothing seems out of order. (Must admit that I'm on DS 4.2, thus 'job sequencer' is strange talk). We use a very similar method - a bit like this.. ---------- deffun GetParamValueViaODBC('param name') calling 'DSU.GetParamValueViaODBC' *** DataStage routine that grabs a...

Alternatively, you could set some synonyms in schema1 pointing to tables in schema2. The down-side is that you will need to be careful with security (i.e. permissions/grants) in Oracle.

Mihai

_________________
desk: 01908448571

Hello


I vote with Xian on this.

I've also received the email in which the CompileAllSetup link is invalid. I wonder if this will get noticed by an Admin ...



Kind regards,
Mihai

_________________
desk: 01908448571

Bala.. We are experiencing the same problem here. The problem has been flagged with Ascential since version 3.x, but no resolution is forthcoming just yet. We have been trying to get a reproduceable environment for years, but without success (even though we are experiencing one of these goodies regu...