DSXchange

Is there a compile script in your "/apps/Ascential/Projects/edw_stage/RT_BP4334" directory and if so, can you execute it?

The easiest and safest way to do this is to do a full project export, create a new project and then do a full project import into the new one.

rani_cute wrote:....KILL -9 PID...

I think that is terrible advice and will cause problems.

Have you specified "Message File" option in the enterprise stage and checked to see if there are any contents?

I had a similar case a while ago where the project had so many entries that, even with categories, the refresh would take minutes. I traced all the calls that I could find and added a number of column indices (I think at one point I added a secondary index for every column in the main tables) and co...

Not scared enough to get a premium membership, though

The important part of the post is visible, the rest you can use the documentation and the search facility to figure out.

Hard to answer that question, as you haven't specified what the "issue" is. Much of the time problems are encountered in transformations, where you get warnings or error when trying functions on null values.

If you add the environment $APT_ORA_WRITE_FILES then the SQLLDR files will be visible to you after the run. If you check the data files and the precision in them is correct then you will need to look at Oracle regarding fixing this. Only if the data files contain truncated values is the error on the...

In the lookup derivation you can specify a RANGE lookup.

No need to handle them at all. The only issue is when you try to write a null to a non-nullable column.

There is no builtin easy way to do this in the VOC file for those not familiar with TCL. I don't know what site you are at, but the name sounds like a job I might have written. The code will most likely select all "F"ile type VOC entries, then check to see if the data and dictionary part files exist...

One of the functions available to you is DateFromDaysSince(). 10 weeks is 70 days.

If you output the resulting column from the StringToDate('0000-01-01') function to a peek stage is it displayed correctly?