DSXchange

hi, when i give the command select * from DS_JOBOBJECTS.it displaying all the objects which are in DS_JOBOBJECTS.my manager is saying that its not displaying all the information, and also the data is unstructured without any delimiters.can anyone help me out how can i analyze the data in universe. c...

Hi Gurus, my universe has data from various sources, we couldn't identify the data is from which source is that from oracle or from some other databases, so is there any utility that can access this universe database and returns the o/p that data is from oracle or db2.can anyone please help me with ...

hi, my design is source universe target-oracle odbc is not compatible to universe,i want to list all the data in universe. the main problem is we dont know data is from which source, since the data is from various sources.can anyone help me with the most compatible way to connect to universe.iam not...

hi,
iam trying to connect the sales datasourcewhich is in uv folder.
iam getting error.The error is like this, dbcapper-could not login to database as invalid username and password.how can i figure out the actual user name and password,iam logging in as administrator.

cheers;
vijay

Hi, how can i make universe files accessible to odbc clinets, how can i connect my source to universe, iam connecting through odbc, but its not connecting, is there some thing to do in uvfile to connect to universe.can anyone help me out in the pre-requisties in connecting odbc to universe. cheers; ...

Hi,
Thanks very much,can i find usage analysis of column or metadata.



cheers;
vijay

Hi,
i think usage analysis just shows the interdependencies b/w 2 jobs . how can i find the impact of meta-data like if we eliminate one column or add a column, it should show the impact and lineage on the job.Do we have any plug-in stage for such analysis.

cheers;
vijay

hi,
how can we find data lineage , i mean is there any plug-in to find data lineage.

cheers;
vijay

hi, for ex: we are using command interface utility like this SELECT @ID, NAME "Job_Name", OBJID, OBJTYPE, OBJNAME, OBJIDNO FROM PRJ_DATA_DS_JOBOBJECTS WHERE @ID LIKE '%ROOT%' AND OLETYPE LIKE '%Defn%' AND OBJTYPE='J' i couldn't understand what is meant by object here.our team members are i...

hi, actually we are using universe as out target database, we are using command line interfaces to access the universe database.i got a job"build dsjobobjects hash", i want to get information about this job created in project "vijay".i want to get entire information about this jo...

hi, iam stuck up with a strange problem.what are the hardware req for installing enterprise edition, i know that parallel jobs can be run on smp or MPP systems and on unix server, can't parallel jobs run on standalone systems with more memory space, i know that the load should be shared among diff n...

hi, i need to work on access databases.my problem is iam not able to intialize them. IN THE CONNECTION MANAGER. CONNECTION TYPE IS REPOSITORY WHICH IS DEFAULT. DATASOURCE NAME IS PSDB WHICH IS THE DSN CREATED BY PROFILE STAGE WHILE INSTALLING, WHICH IS CONNECTED TO SQL SERVER. IN THE LOAD METADATA I...

HI,
IN THE LOAD METADATA I CREATED SYSTEM DSN USING ACCESS DRIVERS.I DIDN'T CLEARLY MENTION IN MY PREVIOUS POST.

CHEERS;
VIJAY

i created system dsn. i need to wwwork on access databases.This is what i have given. IN THE CONNECTION MANAGER. CONNECTION TYPE IS REPOSITORY WHICH IS DEFAULT. DATASOURCE NAME IS PSDB WHICH IS THE DSN CREATED BY PROFILE STAGE WHILE INSTALLING, WHICH IS CONNECTED TO SQL SERVER. IN THE LOAD METADATA ...

Hi,
it comes up with the message load metadata process is halted.

cheers;
dileep