DSXchange

Hi, I know that, "If both Type 1 and Type 2 changes exist for the same record, the Type 2 change takes precedence over the Type 1 change. This means that a new dimension record is first created, and then the Type 1 changes are applied to the newly created record only. The Type 1 changes in this...

The big difference is that the version 8 DSX file will have version 8 components in it ... Hmm, apart from that, nothing major? Or, let me ask this way, say the dsx file exported from DS version 7 is imported into v8x, then exported again, would the changes be massive? (I don't have a DS 8 to try o...

"The SCD stage provides nine purpose codes to support dimension processing. The (blank) means that the column has no SCD purpose. This purpose code is the default." I'm wondering what the blank purpose code actually means. If my scd dimension has a field which purpose code is blank, will ...

Again, exactly the answers that I was looking for! Thanks a lot. One more question to make it complete, if I use " Don't Sort - Previously Sorted ", will the "key field changed", "group changed" DS fields get popIulated correctly? If no, I do have to "re-sort"...

asorrell wrote:Yes, you can ..., however there are considerations . . .

Thanks a lot, exactly the answers that I was looking for.

Anyone has more concerns?

Thanks

Hi,

I don't have a DS 8 to try out myself so I have to ask here -- does the dsx file exported from DS version 7 and 8 have huge differences?

Has anyone had a need to import DS 8 dsx files into DS 7?

Thanks

Hi,

Might not be that common, but I'm just wondering if it is possible to have different parallel threads in same stage? E.g.,



This might be helpful during data preparation stage.

Thanks

Hi,

It is recommended to use the "same" method when the data is sorted in previous stages, however, I'm wondering what if the previous stage is a database stage, that sorts data using the "order by" sql clause.

Can I still use the "same"sorting method?

thanks

Why not just have the Sequential File stage generate the row number? That would serve as the key you seek. ... Ops, spoke too soon. Actually, the limitation is at the Column Import stage. I'm using the schema file as the Column Method of the Column Import stage. I.e., my Output link Mapping was emp...

ray.wurlod wrote:Why not just have the Sequential File stage generate the row number? That would serve as the key you seek. ...

Ah, good idea, didn't know that.

Type: Output Column
Adds an unsigned BigInt column with the specified name to the output that contains the row number.

thanks

simply map the surrogate key column from the input link to the output link (as you would in most other stages) on the Output link Mapping tab. Oh, just figured out why you think that way. No that doesn't work for my case because I'm using schema file as the Column Method of the Column Import stage....

So to handle OK, did i do it right by creating an output link that leads to a sequence and which in turn does nothing or is there any other way to handle OK knowing I really don't want to trigger anything just handle it. Did you mean Return Value="0" or 1? Because Exit status 0 is handled...

thanks everyone for the explanation, especially chulett for your clarification!

Thanks for your reply Ray, Unfortunately, I was having a hard time trying to interpret what you were trying to say, 'cause Tabs are GUI concept, whereas folders are files system concept. Before asking further questions on it, let's find some common ground. I'm using DS 7.5, and to specify details ab...

Thanks a lot for the answers. I tried to find the answer myself. E.g., I read the coredevgde.pdf, ie, Designer Guide, but only to find: Using Job Parameters in Parallel Jobs You can use the defined parameters by specifying them in place of properties in a parallel job stage editor. ... but nothing s...