DSXchange

Yes, that would be the typical solution to this particular problem, the use of 'in-band' nulls on both sides of the lookup. ... Could yo please let me know which function we can use to resolve this particular issue. While comparing we need to change the null value into some defualt value by doing t...

Can i do it this way, while comparing(look up) replace null with some value on both the sides(both source and lookup), so that it matches the constraint and the records will flow to the target.

All you need to check for null is one of the Key columns. That or use the NOTFOUND link variable if this is a hashed file lookup. ... My qurey is as below, i hope this is not ambigous I have 9 columns as lookup fields(key columns but it is nullable) out of which 4 are coming as null. if we are havi...

I am having a constraint at the transformer level for insert else update, we are comparing 9 column all of them are nullable fields, using these 9 fields we are either updating or inserting the records, My job is as below Lookup | | v Source--->transformer---->insert the records(OCI stage) | -------...

Thanks Craig, i have used a logic which will compare current id and previous id and also i have used hash file to produce the output...it's working now..

but my concern is i have 43 derived columns like this...does this slow down the performance.. if so could you give me the tips to counter that..

HI, I need to convert from rows to column inorder to create derive columns for eq: ID NAME ATTR_NAME ATTR_VALUE 12521 GENERAL TEMPLATE NAME V 12521 GENERAL RF ZONE TBD Output should be ID TEMPLATE NAME RF ZONE 12521 V TBD Please let me know how to do this using stage variable.. or any other method i...