DSXchange

Guys,

New to parallel edition.

Wanted to know when to go for sparse lookup and when to go for normal lkup?

Thanks in advance.
Nilesh

Can anyone suggest links to download the datastage px pdf which includes
information about admin,manager and designer ?

Thanks in advance.

Hi, I am using one source table,one lookup table and finally in the end i am using the same source table to update the records. I am getting error in the job as deadlock detected while waiting for resource. What properties needs to be set in the stage so that it will not keep source table locked? As...

Hi, I am following error while doing lookup using lookup stage. main_program: Data set, file set, or file "Lookup_84:DSLink87.v": Non-pipe (or non-virtual data set) with .v in its name Data set, file set, or file "Transformer:DSLink89.v": Non-pipe (or non-virtual data set) with ....

Hi

Can anybody tell me what DSExecute command does?

Thanks,
Nilesh

Hello

Can anybody tell me if want to find the i/p tables,source files or entire job details what are the different ways of finding it?

Thanks in advance.
Nilesh

Hi,
Can anybody tell me what is staging variable,derivations and constraints in datastage.

And what is the order of execution?

Thanks in advance.
Nilesh

Hi,

I am trying to set up new project using administrator.I am getting following pop up message

Error calling subroutine *DataStage*DSR.ADMIN
check datastage is set up correctly in project uv.


Please help me out to solve the problem.

Thanks in advance
Nilesh

Hi, I am using CSV file as my input stage with date data type defined as varchar2(20) . The format is date with timestamp.My target data type is date. I also want to preserve its timestamp. My target database is oracle10g. Can anybody help me out how do i make conversion from varchar to date in tran...

Hi, My requirement is like this.I have one column whoes data type is varchar and data is like 4/17/2002 00:00:00 I am mapping this column with my target column whoes data type is date. Can anybody tell me the funciton to convert it into date format. I need to retain all the 18 characters of the orig...

Hi,

I would like to pull data from MS-Access database.How do i do that in datastage.

Thanks in advance.
Nilesh

Hi,

I am running my jobs through the sequence.I set the properties of sequence as restartable.Now if one of the job in the sequence is aborted.I would like to know what this restartable property of sequence will do?


Thanks in advance.
Nilesh

Hi,

Can anybody tell me the commands for starting up and shut down of datastage server.

My datastage server is hosted on unix.

Thanks in advance
Nilesh

Hi,

I am getting data in .xls format.I am converting it in .CSV format and loading it.But in CSV say in one column i am getting double comma's in one colmn so it gives me error.

Is there any other way round for this problem?


Thanks in advance.
Nilesh

Hi, What are the areas in datastage to look upon for tunning job? Say for upserts what should be the transaction array size? for insert updates what should be the transaction array size? If anybody has more suggestions then please let me know? Also i want to run the job on sun solaris unix.What comm...