DSXchange

whatever you specified logic will work previous examples. But for particular employee demotion also will happen.How to implement below condition also. I need to Backtrack recent salary Effective date. Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4500 1234 01-01-2007 5000 1234 ...

I need to Backtrack recent salary Effective date. Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4000 1234 01-01-2007 4000 1234 01-02-2007 40 ... You can use like this : Example :1 Emplid EffDate Salary Monthly 1234 02-02-2001 3000 1234 01-12-2006 4000 1234 01-01-2007 4000 1234 ...

vijaykumar wrote:Hi Gurus,
I have designed a sequencer and scheduled that sequencer at night.

Iam getting error in my sequence.Can you please help me with the techniques to handle the sequencer which has aborted at uneven times.


cheers;
Vijay

What error your getting ?, send more details. :D

Hi, When I run the job I am getting following error.There is no clue in the log.(some times its working fine).Please anybody can help. Sorce is Dataset and some transformations and loading in to Netezza database. ERROR: ORCHESTRATE step execution terminating due to SIGINT Parallel job was aborted T...

Tried to use all of the following stmts in the OPEN command of oracle enterprise stage (DS 7.5.1) and get the above error, did anyone get a resolution on this ? 'DELETE FROM TABLE1' 'DELETE FROM TABLE1;' "DELETE FROM TABLE1" "DELETE FROM TABLE1;" DELETE FROM TABLE1 I am using th...

I just had this happen as well. It turns out someone borrowed my computer over the weekend and toggled Annotations off. When the client is set not to display annotations it won't let you add any annotations either. The button looks like a capital "A" in the toolbar. If the button is depre...

Hi, I am reading data as numeric(9,3) and the data is like 1.22,1.00,0.00.1.234,1.230 and want the output data in the below format as 1.22,1,0,1.234,1.23 how to achieve this? Thanks, kd813 Hi, are you talking about remove null/0 values which are placed after decimal point, say 1.00 to 1, is it ? Ca...

HI Folks, I design a job which will dump records from file(data file) to Table. I used Oracle OCI Load stage of AUTOMATIC option.When I run the job my job got aborted with the following error message SqlLdr_Tst..Tgt_Market_Trade: Internal Error: Unable to initialize the Direct Path Context ORA-0237...

Put parallelism into the DataStage job. That's why I asked about Enterprise Edition. However it's also possible in server jobs - you can have multiple connections to the database through the same st ... i mean to say i have given parallelism in query we dont have parallel edition. i ll give u the q...

uccio2002 wrote:Hi all i'm looking to convert some jobs using oracle oci in job using odbc oci. Do it exist any tool that do it (e.g. working on dsx)?
thank's antonio

In Server/Parllel i haven't seen the ODBC OCI, can you give more details

I started all over again. In designer, in hash file stage, I left the account name blank so it will take current project name by default, then I specify filename and checked create file option, job ran fine. But I can't find the hash file that it created. I went to Manager and checked, can't find t...

Hi , I wanted to do a self join with a table which it is having data around 10 crores of rows. ,Which is the best method to do that. Please suggest.. Thanks in advance.. Sorry, but could you please specify what are 10 crores ? 10 millions rows ? In that case I would check if this is really usefull ...