DSXchange

Hi, I have admin privileges and I am logged on to DS Administrator client but I am unable to see the import and Export buttons,I want to Import/Export the Environment variables. Admin-->Selected Project -->Environment -->User Defined variables Note: I am using Datastage Version 8.5 According to the ...

Is it that simple ? Don't we need to set the configuration file and all of the other necessary things ? I have tried it and following is the command I have issued: orchadmin dump -delim ';' hdw_prevday_R1Cards_mly_iu.ds > /home/pfint2/hdw_prevday_R1Cards_mly_iu_20101221.DAT and following is the erro...

Hello, Is there any Osh command to export the DataSet into a file ? The Dataset is on the production box and I need that dataset in Dev. We cannot create a temporary job to move the data from Dataset to File in production. Please let me know or point me to any previous posting for the same. (I have ...

Thank you ...

Chulett, Below is the SQL: MERGE INTO DW_STAR_MDLN.DIM_PROGRAM_TEST A USING DW_STG_MDLN2.STG_MCD_PROGRAM B ON (A.PROGRAM_NAME = B.PROGRAM_SHORT_NAME AND A.PROGRAM_TYPE = B.PROGRAM_TYPE) WHEN MATCHED THEN UPDATE SET A.LOAD_CONTROL_SKEY =:3, A.EVENT_TYPE =:4, A.PROCESS_FLG =:5, A.LOAD_TIMESTAMP =TO_TI...

Tried and Tested it. It actually executes both Insert and Update statements one after the other and doesn't do them conditionally ?

Can I use Merge Statement in ORAOCI stage ?

PS: We are on Linux Platform with DataStage 8.1 Server edition connecting to Oracle 10g using OraOci 9i stage..

Actually my question is - if we use CUSTOM SQL with both Insert and Update statements one after the other, will DataStage and Oracle still treat it as Upsert Statement or not ?

We have a situation in which we have to 'Insert else Update' or 'Update else Insert'. It works fine at is is for us. In our project the SKEY are the target tables are generated using Oracle Sequencers which have to called in the Insert statements as they are not - called by Triggers. So, can we make...

We increased the number of records to some 100000+ and following are the observations: JOBA is still not kicking of Job2 and Job3 at the same time. any thoughts ?? 2/4/2009 12:05:57 PM: JOBA: TEST_DGLMA_N_SEQ4_PARALLEL..JobControl (DeleteDataset Routine): Dataset .. is deleted 2/4/2009 12:05:57 PM J...

2/3/2009 1:32:51 PM: JOBA: TEST_DGLMA_N_SEQ4_PARALLEL..JobControl (DeleteDataset Routine): Dataset .. is deleted 2/3/2009 1:32:51 PM: Job2: TEST_DGLMA_N_SEQ4_PARALLEL..JobControl (FileExists Routine): GLMA_Dly_Sls.dat is valid 2/3/2009 1:33:00 PM: Job3: TEST_DGLMA_N_SEQ4_PARALLEL..JobControl (FileEx...

Ray/Chulett, Job2 and Job3 are absolutely independent. JOB4 is designed to run after Job2 and Job3 are successfully completed. Isn't the Sequencer creates one session and fork child processes from that, can it fork simultaneous parallel child processes ? Don't link them together. There ought to be n...

I have tried what you have mentioned. Job2 and Job3 are starting automatically after JOBA is finished. But they are not running in parallel, Job2 is finished and then Job3 is starting. I am saying the above from observing Job Director Log. Any thoughts ?? Sure, run OK triggers from JOBA to both Job2...

Well My bad. I should have mentioned this before.

I need these 2 jobs(Lets say: Job2, Job3) which have to run parallel after JOBA runs successfully.

I hope I am clear this time. So can this happen ?

chulett wrote:Yes, simply don't link them together. ...

Hello,

Is it possible to execute 2 Parallel DataStage jobs parallel within the same JOB Sequence ?

I come from the regular DS world. In the regular DS the values you pass from the shell scripts overwrite the default values and I am assuming the same would happen with PX also and that would be a safe assumption I would say...