DSXchange

Hello Gurus,

please tell about the during for different datastage versions ( v7.5 and v8). and is there some sub-version for v7.5 and v8 ?

thanks very much!

thanks ArndW,

will you please give more detail about why there will occur duplicate or hole for surrogate key created when recurring loading ?

Hello Gurus,

when creating job for initial loading dimension tables, do we have to make surrogate key column for these dimension tables with surrogate key stage ?

or I guess if we can leave the creation of all surrogate key to the phrase of recurring loading .

thanks very much!

Hello Gurus, in aggregator stage, there are two method: method "hash" require hashing partition with grouping keys method "sort" also require hashing partition for input with grouping keys. what's the difference for these two methods ? thanks very much!

Hello Gurus, this is a runtime column propagation question as following case: input column: a, b , c , d transformation: a+b-->e output column: e, c, d or a, b, e, c, d ( please tell me which output columns is correct ) in the job, function for "runtime column propagation " is active. plea...

Hello Gurus, following is the fact for join stage: when we use Join stage, Be particularly careful to observe the nullability properties for input links to any form of Outer Join. Even if the source data is not nullable, the non-key columns must be defined as nullable in the Join stage input in orde...

Hello Gurus, in v7, there are 5 method to implement surrogate key: (1) ETL approach (using surrogate key stage). but where do you maintain the latest surrogate key ? (2) Database approach. bulk load natural keys into a database and into a key mapping table. but I for every new record with new keys, ...

Hello Gurus, I want to summarize the approad to develop SCD . (1) using transform stage to capture change , to implement change.( including insert/delete/update) (2) using change capture stage/change apply (3) using scd stage is there any other approach to implement SCD ? thanks very mcu!

Hello, Gurus,

when I am developing ETL processes by DATASTAGE, where should I use other technology (such as unix script&sql script) during develping?

thanks very mcuh!

sure, I am DW QA right now, but I want to be a ETL developer. so will you please give me a detail description about the whole process for ETL developing using DATASTAGE . or please recomment where can I get that information.

Hello Gurus,

will you please tell me what ETL develoer do in a project from scratch ?

thanks very mcuh!

Hello Gurus,

in v8, we can use scd stage to implement scd type 1/2. so why do we have to leave change capture and change apply stage there? is there any other usage scenario for these two stage ?

thanks vey mcuh!

thanks, I got it

thanks, I got it

thanks, I got it