DSXchange

It works! I was using isnull vs ISNULL to handle and I think it is case sensitive.

In the hash file look up there is a function called NOTFOUND. Is this not relevant in parallel jobs?

Thanks!

I have set the lookup stage conditions to 'continue' on lookup failure. These lookups are surrogate key lookup. It's defaulting to 0 for these values. Is there a way to default to a different value, let's say -1?

Thanks

I used setnull() and it works. I think @NULL works only in server jobs.

Maybe this is for another topic, I only see 5-6 system variables in parallel job while using transformer. Is there any setting I need to change to see all of them?

Thanks

Also it says @NULL not defined. I do not see @NULL defined under system variable

The if expression is not evaluating to true. It is not inserting even "NULL" instead it's inserting 0

Is there a way to convert blank space to NULL. We have fields from the source application that can have ' ' representing NULL. We would like to load NULL in DW. IF (LEN(TRIM(lnk_from_src.FIELD_XYZ," ","A")) = 0 or lnk_from_src.FIELD_XYZ, = " ") THEN "NULL" ELS...

New to DS parallel edition. I am trying to build a DS job for a fact table which has references to 35 dimensions (via Surrogate key). What is the best way to populate the Surrogate keys. I do not want to form a gaint SQL with left outer join to reference tables from driving table. Rather I would lik...

My scenario doesn't work then? The join key column is different for different set of tables. For A & B it is ID1 which is identically named and have same data types, similarly for B & C it is ID2 and B & D is ID3. The single join stage on more than two tables work only when all the table...

Yes you are correct about the join. Yes, I was able to make it work with 3 join stages. So we cannot use one join stage at all for this scenario? When you say, input needs to be partitioned and sorted, do you mean, Choosing a 'collector type' (one of ordered, roundrobin, sort merge) for each input l...

Two tables are from Oracle, 1 table from SQL server and one is a file. So these are disparate sources. I am trying to achieve using Join operator/stage what the above sql would do

New to DS. I am trying join 4 tables using the Join stage. The table structure are as follows Tab_A ID1 -->Key xyz TAB_B ID1 --> Common Key for B & A ID2 --> Common Key for B & C ID3 --> Common Key for B & D lmn TAB_C ID2 -->Key pqr TAB_D ID3 --> abc In SQL we would join as follows Selec...