DSXchange

Greetings to all, Here is an update. I reversed the condition as follows: Instead of: if isnull(HOP_COV.COVERAGE_KEY) or NOT(ISNULL(INPUT_STREAM.COVERAGE_EXP_DT)) then KeyMgtGetNextValueConcurrent(1) else NextCovKey I changed it as: if NOT(ISNULL(INPUT_STREAM.COVERAGE_EXP_DT)) or isnull(HOP_COV.COVE...

The version I use is 6.0.1.5.

The lookup stage is not an hash file. It is a table on sql server.

1stpoint, I already have a surrogate key in this table which is the primary key. I was trying to the checksum as an alternate key. Michael I think I will go with the second method you suggested. That is concatenating all the fields and make that as one field. May be I will use the same field as the ...

It returns the previous value. I have five records in my test case. the first four have nulls in the coverage_exp_dt but they satisfy the first condition (hop_cov.coverage_key is null) so it returns the following four values one per record: Natural_key Seq_key 1 578 2 579 3 580 4 581 The fifth one h...

John, COVERAGE_EXP_DT is a date field. It is not a fk to the date table.It is always either NULL or a date in that field. No blanks in this field. Atleast not in the bunch of records i am testing with. Also I tried this in debug mode and the INPUT_STREAM.COVERAGE_EXP_DT does contain a date, so i wou...

Here you go:

Hello all, I am trying to setup a dirty dimension for which i dont have a natural key to specify. I am thinking of using the checksum value of the row as a field in this table and use that as a natural key. Now, here are my questions: 1. is it a good idea to use that as an alternate key? (primary ke...

Hello all, I am incrementing a stage variable based on two conditions. It looks something like this: NextKey = if (isnull(ref_link.ref_key)) or not(isnull(input_link.exp_dt)) then KeyGetNextConcurrent(1) else NextKey This increment works for the first condition but not the second. When ref_link retu...

Thanks Ray. After pulling out my hairs for couple of hours, thats exactly what I ended up doing.

Thanks again,

I am using OCI8 stage and I dont see an option to convert into user-defined sql????

Hello all,

In one of my jobs, I am using Insert new or update existing rows. In that I want to move a field from my input stage only while inserting new rows. I want to keep the old value when it is updating an existing row. How can I do that?

Any help is much appreciated.

Regards,

Aravind.

link2 fails due to database constraints. e.g. NULLS in non-null fields, duplicate keys where there is a unique constraint etc.

Thanks,

Thanks Craig, I have three links and all three links have 'rollback' as 'on Fail' action and 'Continue' as 'On Skip' action. I dont want the previous rows (that are already committed to the database) to be rolledback. I only want the current row to be rolled back. Just exactly as you mentioned, If L...

Hello all, I am using Transaction Grouping in one of my jobs. I have one OCI8 stage with three input links coming into it. All three are insert new rows or update existing rows. If link2 or link3 fails, I want all *previous* links to be rolled back also. How can I achieve this? Transaction grouping ...

I found the problem. A decimal field had nulls in it and thats why it bombed.