DSXchange

Hi, I am working on DataStage Enterprise Edition 7.5.1A on GRID.I have design issue w.r.t GRID. I have 2 jobs first job extracts 2 million records and loads to a dataset. Second job loads from dataset to oracle stage after doing change capture. I have a sequence for this 2 jobs with Sequencer.sh exc...

Hi, I am running a job where source is oracle and target is oracle. My source contain user defined SQL where i perform left outer join and based on a filter condition in tranformer i move data to target oracle table(truncate and load) job is aborting with below error message.There are total 6 column...

Hi I am getting the below error when running one of my jobs today DataStage Job 510 Phantom 17328 Program "DSD.StageRun": Line 617, Unable to open the operating system file "DSD_BP.O/JOB.37229231.DT.1407913584.TRANS1". [ENOENT] No such file or directory Program "DSD.StageRun...

Hi,

Can i use metastage to capture and store all of logical and physical metadta from

ERWIN
Oracle Designer
Power Designer


Thanks

Hi, I am working on DS7.5.1A on HP-UX. we are not having the email clips (the picture icon ) for the attachments. i.e When you see the list of emails in the inbox the attachment icon is missing but if you open the email the attachments are actually in there. Is there any setting i am missing on Data...

Sorry. I did not give the inputarg in the right format. Thats why it dint work earlier. The format had to be something like "#$FTP_DIR_Parm#TEST.INC timeout:": TOTAL_TIME :"/": POLL_TIME for it to work. I was able to parameterize these two variables. Thanks guys.

We are using DSWaitForFile Function in a job sequence to wait for a particular file. The Inputarg is like "#$FTP_DIR_Parm#TEST.INC timeout:60/10". We want to parameterize the total wait time (60) and the poll time (10). We tried to give something like "#$FTP_DIR_Parm#TEST.INC timeout:...

Thanks ArndW/ray.wurlod for your inputs.

I wanted to know how can we leverage Datastage PX features with Grid Computing? Does DS support grid computing :?: Ascential/IBM market Datastage enterprise edition as grid enable integration tool. If yes then how can we use pool of server for running the datastage jobs? I understand that datastage ...

Hi ArndW, When I used the Environment variable "APT_ORACLE_PRESERVE_BLANKS " in job parameter with Setting as True. Even then instead of a space being populated , Null is getting populated. I am really not sure why this is happening. To over come this problem, I tried using Close Command o...

Hi ArndW, Thanks again. I tried the option of APT_ORACLE_PRESERVE_BLANKS in job parameter with setting True. But even then the issue persists. My source is Oacle and Target is again Oracle. In the source I am using user defined Query in follwing way. NVL(Source Field,' ') as Source Field and Then it...

Hi, Thanks for reply, When I load the data in flat file or a dataset then I am able to see a space inserted. But when I load into Oracle table, Then its inserting as Null. Where can I see this APT_ORACLE_PRESERVE_BLANKS and what setting I need to do to rectify this issue. Thanks in advance. Regs San...

Hi,

I am inserting space into the target field (oracle table), something like this
if isnull(source field) then space(1) else source field

But somehow it seems null is being inserted instead of space.

Any thoughts on this.
Thanks in advance.

regs
santosh.

Hi,

I am Using Merge Stage , But when I execute the job I am getting an Error like
" Dropping component "Column name" because of a prior component with the same name."
Any idea why this error is coming.

Thanks in advance.

Regs
Santosh.

Hi,

Can I have Stored procedure Stage in a Datastage job as a stand alone stage. i.e no input parameter, and no return values,
I just need to process every thing in the procedure.But need call the same using DS job

will this scenario work?
Thanks in advance

Regs
Santosh