DSXchange

Thanks much Ernie for the advice.

Somehow building up sqls to dig ourselves is much flexible than using tools i guess. I am a novice when it comes to various informationServer peripheral tools .... i hope i figure out what Metadata Workbench has to offer.

XMETA is disappointingly hard to decipher. Wondering if anyone figured out a way to join the XMETA table "DATASTAGEX_XMETAGEN_DSCOLUMNDEFINITIONC2E76D84" (provides column names and properties ) to a table that provides JOB NAME and/or STAGE NAME. I am on lookout for list of jobs that has c...

I have specified two columns as business keys. The lookup succeeds because I can see that my type 1 columns are updated. The problem is that my surrogate key also gets updated with a new key. I could exclude the dim id/surrogate key for update in the update part of the upsert. But then the dimid in ...

Any ideas?

My version is 8.1

Thank you in advance!

No, my updates are just type 1.

This should mean that a new dimid would not be generated.

While trying to laborate with the scd stage, I ran into the following. The scd-stage sends update and inserts to the upsert link. My problem is that every record gets a new dimension id. This is ok for new records, but not for updates. I thought that updates would keep the old dimid. The problem her...