DSXchange

Hi All, I have sequencer where I have 6 dimensiond , two facts etc, job1---->job2----> job3---->job4----> sequencer(ALL)-------->Fact job5---->job6----> All six dimensions are independent , all are running independently , but when one of the job is getting aborted , if I run the sequence , it runs f...

Hi ,

I am using hash partitioning for both before and after dataset , I used sort stage , and same partitioning keys for sort and change capture , the meta data is same for both , though the data has not been changed but I am getting updates ,

pl suggest what may be the cause ,

thanks

Thanks for the replay ,

But I have used the option explicite keys and all values , and the before and after meta data table definition are loaded from the same that is target table meta data ,

then also the meta data will cause the problem ,

pl suggets ,

thanks

Hi , I am using scd type 2 , I am using change capture stage , which is working fine with the sample data , but when I am trying to load the real data , update is failing , though the records in before and after sets are similar it is giving update that is change_code=3 , I ceated two table with 5 r...

Hi , I want to find out the records which got deleted from source but still in the target , set the delete flag yes for those records. I used change capture stage so I am getting the deleted records but all fields are null as I am getting data from source which is my after data set , there I dont ha...

Thanks kenneth , as this is happing quite often , evey 5 min , I am saving the job with anothe name and compiling , as i have to load the data by aftenoon I am looking against table , which has null , though I used option in modify stage colunm name = Handle_Null(colmn name , "Null") its g...

Hi ,

Now recently whenever I am tying to compile a job , I am often getting the message , job is being monitored I am enable to compile the job ,

pl suggest , as we have critical dead line , I am stuck in between

thnks

Hi , We had a problem with datastage metadata when we installed it without NLS. The jobs when compiled gave the error 'NLS has to be enabled'. So i reinstalled the server with NLS enabled, but still I am getting the error as : The NLS character map <ASCL_ASCII> is specified, but NLS_LANG is not set;...

[quote="kcbland"]The command line program dsjob has a RESET option and a RUN option. You can use this on the individual job. However, your Sequence job cannot be used unless you built it for restartability.[/quote] what is restartability ? Can i use if then else and get the parameter from ...

hi all, I am new this forum , please help me out with few ?s , Suppose there are 20 jobs in sequencer and 4 th job is failed , how can i handled it through unix command , i know it is DSRUNJOB , but can u elaborate and how to reset is and rerun the job again, Waiting for the replay , thanks , K

Hi all ,

1: If I want to store intermediate data , which stage I should use , data set , file set or sequencial file set in parallel jobs ?

2: How to migrate jobs from vrsion 6 to 7.5 and change them from parallel to server ?


Thanks in advance ,

kw