DSXchange

Hi,

I have a input stage and pass it to aggregator stage and insert the count in sequential file

If i have 0 records in the file i want to update the count as 0. But it is updating the file with Null..

Is there a way to do that?

Hi , I am getting the following error Join_227: Error when checking operator: Key field "DEST_LOC_I" was not found in the view-adapted input schema I have searched the forum and checked the nullability of input and reference in the Join stage. Both are same There are many join stages befor...

Moving it to parallel forum

Hi , I am getting the following error Join_227: Error when checking operator: Key field "DEST_LOC_I" was not found in the view-adapted input schema I have searched the forum and checked the nullability of input and reference in the Join stage. Both are same There are many join stages befor...

Hi, I have a requirement to create sequence numbers for each group I have the following columns in the input Col1-Col2-Col3-Col4 1111-2222-3333-444 1111-2222-3333-444 1111-2222-3333-444 1111-2222-3333-555 1111-2222-3333-555 So, I have two groups now One is 1111-2222-3333-444 The next is 1111-2222-33...

hi,

the dataset does not exist

We are able to run other jobs and created dataset in the same location.

HI, I am getting the following error while running the job main_program: Incomplete read of header from descriptor file /work/DAR/data_wrk/a.ds: expected 56, got 5 main_program: Error reading ORCHESTRATE File Dataset descriptor for '/work/DAR/data_wrk/a.ds'. /work/DAR/data_wrk/a.ds: Data set initial...

Thanks for your responses..I am trying to get the information whether it is stored procedure or sql scripts, but havent got anything which can be re-used..if anyone has the info, can you please pass it on to me..

will the job not abort if it is a primary key violation error?

I have a job to insert records into a target table with oracle sequence.next val value for the primary key. The oracle sequence is cyclic, and if i get the primary constraint violation for few number of records(ex 50 records out of 1 million), then i dont want to abort the job, rather i want to run ...

Hi,

Is there any predefined script or function or routine to populate the date dimension table. or how is it normally done?

I need the following in Date_dim

Date
Day number
Calender day number
Month Number.

Thanks

Hi,

I want to generate sequence numbers of a group of keys

My input records are like this

Col A|Col B|Col c

aaa|bbb|ccc
aaa|bbb|ccc
ddd|dfd|sdc
sds|oio|pop

I want the output like

Col A|Col B|Col c|Col D

aaa|bbb|ccc|1
aaa|bbb|ccc|2
ddd|dfd|sdc|1
sds|oio|pop|1

How can i achieve this..

Try to get the matched constraint that lookup with those range of records

---how to lookup for those ranges.

Hi, I have to lookup a hour dimension table and get the sequence id for the same For ex, i have the time like this 01:10 And in the dim table, i have values like this Seq_i|hr start time|hr end time 1111|01:00|01:59 So i need to get the value 1111 since my input 01:10 is in between hr start time and...

Hi, I am doing rollups from the incoming records. I have a group based on which i am summing multiple columns and output the same in multiple columns and finding the count. Can we do this using one stage or do we need multiple stages. Ex: Col A|Col B|Col C|Col D|Col E aaaa|bbbbb|1234|3456 |654 aaaa|...