DSXchange

I dont see these purpose codes any where on the output link? Any thoughts where its storing them on the output link? I haven't seen anything being stored anywhere. The Upsert that gets generated will try to do an update based on the surrogate key, if it fails because of a new surrogate key then it ...

We found a solution ! I'd like to thank the academy :wink:, a special thanks to Norman Simpson :) for finding the solution, Jean Porter for inspiring it and ArndW for caring :) ! We added the following to the user defined environment variables for the project: NLS_NUMERIC_CHARACTERS=., it did the tr...

Are either your database or DataStage using a locale which might use ',' as the decimal delimiter? We thought of that... but after verification and changes done in order to eliminate any doubts... we have them both with the same NLS. One more thing, the regional settings on the windows server indic...

Hello everyone, I need your help :) Configuration: We have a brand new installation of PX v8.1 on a Windows Server. -The Database is ORACLE 11g. -Two (2) Oracle clients are installed on the server machine is 9.2.0 and 11.1.0. -Currently using the 9.2.0 Oracle client on the server Problem: We cannot ...

Did you duplicate the column in your lookup?
The column might not appear on the left side, but you can still access it if you edit (double-click) the derivation and choose input column"[/code]

I don't have access to test anything before monday... In version 8.1 (which I've tested with) the SCD stage updates the values (in memory) of the reference link columns which you defined with a purpose code. ie: When you reference them, it's too late ... the value has changed ... and you don't have ...

if IsNull(lkp_Link.Eff_Date) Then CurrentTimestamp() Else if IsValid('Date',lkp_Link.Eff_Date) Then lkp_Link.Eff_Date Else CurrentTimestamp() My datatype for this column on the Columns tab on the Output tab is Timestamp and on the Columns tab in the Input tab is also Timestamp You seem to be valida...

if IsNull(lkp_Link.Eff_Date) Then CurrentTimestamp() Else if IsValid('Date',lkp_Link.Eff_Date) Then lkp_Link.Eff_Date Else CurrentTimestamp() My datatype for this column on the Columns tab on the Output tab is Timestamp and on the Columns tab in the Input tab is also Timestamp You seem to be valida...

Figured this out! :D (thx Norman :idea: ) Hello everyone, PROBLEM: The output map doesn't return the previous value of the dimension (prior to the change). It seems to return the value after the change (from memory). [...] Question 1: Is this a bug, or is the OUTPUT MAP supposed to work this way? :?...

Hello everyone, Long time listener... first time caller ... :wink: I've spent the last couple of days trying to master the behaviour of the SCD stage in order to implement its usage on our spanking new project. I followed the recipe from "IBM InfoSphere DataStage Data Flow and Job Design" ...

Thanks for your prompt replies! This clarifies a lot of things :) We do have lots of BASIC batch job control. The code has been developed already ... so I don't know how much help the new sequencers will be :?: On the other hand, HTML reporting is a very nice to have... :D specially that we have to ...

Hello Everyone, I am trying to find information to build a business case to migrate DataStage Server from version 7.1 to version 7.5. We are not directly supported by Ascential (IBM now) as the software is provided through an agreement with PeopleSoft (formerly JDEdwards, now Oracle :)). What I have...

Well they both offer the advantage of highlighting your code with color. I am not too familiar with TextPad but UltraEdit has these features that are useful to me: -Disk based text editing - supports files in excess of 4GB, minimum RAM used even for multi-megabyte files -Syntax highlighting - config...