DSXchange

Hi, When i use following query in TCL : SELECT * from RT_STATUS415; I get following data : TestJob.Befor e.1 TestJob.After .2 TestJob.Befor e.oeeDimFF Also, LIST.DICT RT_STATUS shows only one column name '@ID' DICT RT_STATUS 09:43:47am 26 May 2010 Page 1 Type & Field......... Field. Field..........

rohithmuthyala wrote:Change capture stage will not sort the data by default on key column. One needs to sort the data and hash partition the data on key column(s) explicitly in sort stage or in the same stage.

Thanks Rohit.
But in that case what will the ""Sort Order" option do in change capture stage?

Hi, As per the DS Manual "The change Capture stage assumes the data to be sorted and hash partitoned". But,in the "Properties tab" of Change Capture stage,the "Sort Order" option is also present. Does it mean that change capture stage will by default sort the data on th...

Search forum for "RTLogging".You will get the answer.

This link may help : http://dsxchange.com/viewtopic.php?t=13 ... f7a4ff5f58

ray.wurlod wrote:I gave my solution 40 minutes ago. ...

That's great.I really appreciate the good contributors like you.Keep up the good work...

What evidence do you have that Oracle is involved? Funnily enough, not everyone in the world uses Oracle. And what is the evidence given that any file is being used?In fact..the source is not mentioned in the question itself... You should try putting solution to the problems..rather than making fun...

Okay..So as per your requirement,you need to get all the dates lying between two dates.Then you need to determine days for all those dates. Then,you have to adjust counters accordingly. You will have to create a datastage job and call a stored procedure from the job for this. Following are the steps...

Hi, I have 2 dates. One is migration date which will alwyas have a fixed value.Migration date is passed as job parameter. The other date is coming from source and will have different values. I need to compare 2 dates and if the difference between the 2 dates in greater than 3 working days, I need t...

Datasets are stored in internal format.These can not be searched directly. You will have to write a shell script to accomplish this. Datasets can be viewed using ORCHADMIN DUMP command.You will have to implement this logic in you shell script. Following are the steps : a) In the shell script,accept ...

adding the record number after splitting a file is not a good idea. There are many ways by which the order of the records might get changed. For example : a) Using multiple readers option in sequential file stage will change the order in which the records of files are read. b) What if a record is dr...

kamalshil wrote:Thanks nikhilanshuman ,
After adding it as $PROJDEF in sequence i am able to run the sequence.

Welcome!

try searching for "The configuration does not contain".

there are many posts on this error...

qutesanju wrote:but action set at my target table is insert new or update existing so if in case it's corrosponding entity not found while update so it must insert new record?

but the error message says ... "an action of Update Only has been specified".. !

The operators are running on two nodes. The sequential_row_generator is a sequential stage.It will not run on two nodes.The sort and peek stage are running on two nodes as shown in bold below.(node1 and node2) op0[1p] {(sequential Row_Generator_0) on nodes ( node1[op0,p0] )} op1[2p] {(parallel Sort_...

In the job parameters of your sequence,go to the password parameter and set its value to $PROJDEF . Type this manually in the value field for password environment variable.You will see only ** as the value is encrypted. It seems that the password environment variable is imported,but it's value is se...