DSXchange

Hi,

For date range comparisons the best way to use is "Table Look up" where you have only the Number1 column as key and in the where clause you will have it like
WHERE
Table.Number1 = :1
AND
seq_file.date between Table.date1 and Table.Date2.

Try this and let us know if they work.

Ridar.

Doesn't the rm -r PATHNAME\HASHFILENAME work in deleting it permanently

Hi, Also please check the condition Not(IsNull(Lkp.KeyColumn)) in the transformer. This will make sure you have a matching record in the lookup. Otherwise there are chances that only the constraint is validated. Experts, please correct me if i am wrong. Also, please try to check if all the date form...

Hi, Can you also put up the constraint that you have given in the ransformer? That would help in anlyzing the problem faster. Wrong constraints or wrong key matches can cause such problems. Also the data has to be analysed. If your input key column for the 20 records matches with the lookup key colu...

Hi RK,
One more possiblity is that you have used "Column Generated Query" and have missed the table name in that. Just check that also.

Ridar

Hi rafidwh, Arnd's answer is enough to solve ur problem. But, if u r very much insisting on adding conditions in the transformer(by conditions i hope u r referring to the constraint to be put in the transformer for the look up) then u can check for NULL value returned from the lookup. If the lookup ...

Hi rxs0005, When you fetch data from the source ORACLE table itself you can use a where clause in the query which compares it with the sysdate and fetch only that data. You need not put any constraints in the transformer at all. This is the simplest way i can think of for this problem. Hope this sol...

Hi itznitin, This happens when you are trying to run a job that has aborted in its previous run. If you are calling the job from a sequencer, then you might have to set in the properties page as Reset if required, then Run. If you had missed that, then youmight be getting such errors. Else, if you a...

Hi Arnd, Thanks for the response. We are now only going to do a new setup. So would like to know what are the best possible servers that we could use. Regarding the no. of users it would be around 5 and not real time production. It will be a kind of offshore development. Not a very heavy load initia...

Could anyone suggest a good configuration of a UNIX server for installing Datastage? This will be an isolated Datastage server and no database or any other applications running on it.