DSXchange

To answer the original post, why would you even need to see values that were passed to the key expression when you already have them available? As for the ultimate question about ranged lookups against hashed files for high volumes - forget about using the UV/ODBC interface as it's better than a da...

Thanks for the info So I am back to square one. How do you do a range based lookup using a hash file. I can do it using a OCI stage but we are processing more than 56 million rows and have 4 range based look up so it kills the performance. So I started out to see if I can get the data in hash file a...

I thought there way a way to access a hash file using a odbc stage. But I did not know how. If you go to this site they mention not doing it due to performance issue, but dont explain on how to do it. Any pointer appreciated on this topic. Go to this link and search for ODBC - (I need to use google ...

A modified version of equijoin that we know works looks like this, but problem facing is getting the input variable;es back in the output result. SELECT p.polcy_id, p.poldm_id, p.sc_case_key, p.sc_cont_no, :1, :2, :3 FROM policy p WHERE p.polcy_id = ? and p.STATUS_END_DT >= ? and p.STATUS_STRT_DT <=...

The reason I am returning the variables back is the query is not a equi join it is a > or < than check so once we get the required result how do we get a successful look up without passing the back the input parameters back to the output, so we can do a successful look up. We do have to define those...

Hi, I have this query in oracle which I would like to convert to Universe. My problem is how can I get the variables I passed to the query back in output in Universe. Just replacing it with ? wont help SELECT p.polcy_id, p.poldm_id, p.sc_case_key, p.sc_cont_no, :1, :2, :3 FROM policy p WHERE p.polcy...

Hi, I did some more research and I would like to provide some more details on the problem statement and the problem. Please find below a few details on the Problem. What are we trying to achieve: We have a driver table that is the input for complete process. This table is populated is continuously 2...

Hi, We have a Event table that is populated by another system and the datastage jobs need to read this table and pickup all available evnets and process them. Once it is done done processing that go back to the event table and repeat the process. So the Batch Job will keep looping the whole day and ...