DSXchange

Hi,

Thanks, that's what I thought but thought i might as well ask

Daren

Hi, I am performing a lookup using a lookup stage and potentially, the values being looked up may not exist, which is fine. I have set the stage to CONTINUE if the Lookup fails but the default value for the BIGINT field, which would have been derived from the lookup dataset, is being set to 0 (the l...

chulett wrote:He means the same Data Set.

Thank you :D

Daren not sure why u require 3 jobs .u can have 1 job with append option run in mutliple instance since all data are going in 1 dataset in 3rd job Thanks Sanjay In addition to the above I have amended Job 2 to write to a new (separate) dataset to Job 1, and then amended Job 3 to funnel these using ...

In addition to the above I have amended Job 2 to write to a new (separate) dataset to Job 1, and then amended Job 3 to funnel these using RCP and it works OK. This then proves that the metadata / schema from Job 1 and Job 2 are identical. The APPEND of the DS is obviously causing some sort of issue,...

Hi, I am creating a dataset using OVEWRITE in 1 job and in a successor job, APPENDING to the same dataset. I have RCP turned off and the metadata definitions are identical (I and a colleague have checked). The schema definitions in DS management also match. I run the sequence of Job 1 and Job 2 twi...

Thanks guys - I had thought of the helper table method, but was curious to hear of any problems implementing such a method in your ETL.

Hi, I'm refining a dimensional model that includes several multivalued dimensions at the grain of the fact. Has anybody implemented the ETL surrounding helper / group tables surrounding mutlivalued dimensions as although I am still in the knowledge assimilation phase, I'd like to get a grasp on the ...