DSXchange

May it could be simple databae NULL to NULL compare, which will obviously fail. Try to do the Same Null handling before SCD stage. On both input and reference link. Thanks for the response. So there is no job-level setting that will more cleanly handle NULLs within Parallel jobs? I would think that...

kumar_s wrote:Make the Combinability Mode to False. So that you can nail down the error.

Good Idea. This points out that it is the SCD stage:

scdT_EMP_PROFILE,0: Field 'DVP' from input dataset '0' is NULL. Record dropped.

Any thoughts on how to handle NULLS in an SCD?

Does that DVP used in any of derivation Expression other than straight mapping? There are absolutely no derivation expressions on this field. If I convert the incoming NULL value to empty sting or something else, then it wouldn't match the value being returned from the lookup...and would force a Ty...

We're using an SCD stage with a sequential source (comma delimited with double-quote enclosures) and Oracle Lookup/Target. http://i167.photobucket.com/albums/u138/GatorNutz/px_job.jpg The initial run completed successfully, however the "change" test failed: APT_CombinedOperatorController(0...

some more informaton about the job...

it is a PX job, reads from Oracle, executes approximately 15 or so normal and sparse lookups directly from Oracle, uses a merge then writes to a data set.

I have a job that was running just fine on a single 4 way machine. Then, last week I decided to add a second 4 way machine and built a clustered environment (not sure if the issue is related, but thought it worth mentioning). I received the following errors on both the master and second node: Item #...

Thank you for your posts, I have scheduled a demo and will try to obtain a copy of the paper.

Has anyone implemented Information Analyzer and/or Business Glossary for version 8? I am interested to know if there were any problems with implementation and if the products have proven to be user friendly. Our sales rep is offering both add components at a discount and I am attempting to gain info...

I am attempting to multiply 3 fields together in a transformer, however the output is rounded. for instance .45 shows as 0. all three fields are designated at Decimal (38,2) and my output field is also Decimal 38,2. The output is the same regardless if i write to a sequential file or to my oracle 9i...

Hi All, I am interested in configuring a clustered DS environment. We have out grown our 4x box and the 8x + boxes that my company has recently purchased are all 64 bit Hardware. We are tied to Linux, so upgrading to 64 bit DS is not an option. I have read the px guide and as I understand it, you in...

Also I turned tracing on, the last few lines look like this: ppid=4083:pid=4 ff8:b75f52a0 EXIT SQLFetch with return code 0 (SQL_SUCCESS) HSTMT 0x0863dda8 ppid=4083:pid=4 ff8:b75f52a0 ENTER SQLFetch HSTMT 0x0863dda8 ppid=4083:pid=4 ff8:b75f52a0 EXIT SQLFetch with return code 0 (SQL_SUCCESS) HSTMT 0x0...

Ray,

Have you had success employing the diagnostic tools? it looks as if it requires me to run a script to create a table on my db. Is that how you have used the tool?

Thanks for the replies.

Bill

The behavior is consistent for the same tables - works for some others it does not. I looked at the diagnostic tools in the branded_odbc directory, but I have not been successful in getting it to work. I did find that the server itself was physically moved from one frame to another the night before ...

Sorry Ray, I copied the title from a email section and didn't check before I posted. The SIGINT occurs only when we kill the job after it hangs while trying to extract data from SQL Server.

we experienced a production issue this morning where some of our jobs that are extracting data from SQL Server via the ODBC Enterprise Stage seem to hang - others connecting to the same DB run to completion. For the jobs that are hanging, I am unable to view data via the ODBC stage (Designer becomes...