DSXchange

Yes, it does.

Columns to rows, actually. As an alternative, check this post.

-7 = DSJE_BADSTAGE = "StageName does not refer to a known stage in the job". Check $DSHOME/include/dsapi.h or the online help.

Many factors at work here. How 'fat' are your records? Why a minimum modulus of 1? There have been a number of posting on hashed file details - Ken Bland had an extensive article in a newletter you should be able to find from the home page. Someone else posted this link which should help. And then ...

How can use that target table directily... If we need to access to the table we need to get DB Links beacuse different schema. You don't need a dblink to access a different schema - you'd need one to connect to a different instance however. Or to join tables from different instances as if they were...

This may be very basic question but I am new to Datawarehousing and just started with Datastage. Actually, these aren't DW or DS concepts, they're just Oracle and ODBC questions. You haven't really gotten to the DataStage bits yet. They should just work if this gets setup correctly. Talk to your DB...

1. Yes.

2. Yes.

3. 'ConnectionName' just means what you use in your jobs. Basicall, the 'dsn'.

4. Nope. Client (non-wire) drivers get that from the tns entry.

5. Single entry.

You should be able to do so for your own processes.

You working with Lakshmi?

I use DS Enterprise Edition(Px) and have Oracle as the underlying Database. I am using PeopleSoft as a FrontEnd Application . In which stage of Datastage Px , can i use Connectivity to PEOPLESOFT CRM ? Anything that can connect to Oracle - the Oracle Enterprise stage, for example. ODBC. DRS in Serv...

There ya go - edited for clarity. :D

Three separate front end AIX servers for WebLogic, dev/test/prod - pointing to two HPUX DataStage servers hosting the dev/test and production projects.

Perhaps it would be best if you tell us why you think you need to do this? I can't think of any reason someone new to DataStage would need to take that route - typically you'd stick to the Hashed File stage and save the UV stuff for the advanced class. And before Ray comes along - remember, they are...

BEA WebLogic. HTTP over SOAP. Dev and Prod.

But requires proper permissions. You can only handle your own processes there - unless you are the admin, of course.