How to use transformer as lookup

ramesh_c · Post by **ramesh_c** » Wed Aug 08, 2007 2:59 am

Hi All,

I want to apply the SCD2 in the dimension tables. and I read from ETL stats Tech Tip slowly cahnged dimensions document. In that they are using the transformer stage as loo up . Whan i am trying to inplement this it is not working. Can any bod please tell how we can do this .

Thnaks,
Ramesh.

ArndW · Post by **ArndW** » Wed Aug 08, 2007 3:15 am

You need to use a transform stage in SERVER in order to do a lookup; but in PX there a specific stage called (surprisingly) a lookup stage which you need to use.

vmcburney · Post by **vmcburney** » Wed Aug 08, 2007 5:18 am

Upgrade to version 8 and you get a slowly changing dimension stage (for parallel jobs only).