https://communities.sas.com/t5/SAS-Procedures/DI-studio-which-type-of-scd-will-support/m-p/13858#M2077 SCD Type 2 Loader supports...type 2!!!<BR /> In 9.2 type 1 will also be supported.<BR /> <BR /> Of cource, you are free to implement your own loader which could support other types than no 2, by using the transformation Generator Wizard.<BR /> <BR /> I'm not aware of any limitations of how many Look-up transforms that could fit into a job. But as a general rule, one should put to much into a job, it would not be good from a maintenance point of view.<BR /> <BR /> /Linus Thu, 02 Apr 2009 06:48:39 GMT LinusH 2009-04-02T06:48:39Z https://communities.sas.com/t5/SAS-Procedures/DI-studio-which-type-of-scd-will-support/m-p/13857#M2076 Clarification about the SCD (Slowly changing dimension) and Look up <BR /> <BR /> Di studio will support all the three SCD types or only SCD type two transformation.<BR /> <BR /> and <BR /> <BR /> In a Job how many look up transformations can be used. is there any limit for the job.<BR /> <BR /> Venky. Wed, 01 Apr 2009 12:19:29 GMT https://communities.sas.com/t5/SAS-Procedures/DI-studio-which-type-of-scd-will-support/m-p/13857#M2076 venkatesh 2009-04-01T12:19:29Z https://communities.sas.com/t5/SAS-Procedures/DI-studio-which-type-of-scd-will-support/m-p/13858#M2077 SCD Type 2 Loader supports...type 2!!!<BR /> In 9.2 type 1 will also be supported.<BR /> <BR /> Of cource, you are free to implement your own loader which could support other types than no 2, by using the transformation Generator Wizard.<BR /> <BR /> I'm not aware of any limitations of how many Look-up transforms that could fit into a job. But as a general rule, one should put to much into a job, it would not be good from a maintenance point of view.<BR /> <BR /> /Linus Thu, 02 Apr 2009 06:48:39 GMT https://communities.sas.com/t5/SAS-Procedures/DI-studio-which-type-of-scd-will-support/m-p/13858#M2077 LinusH 2009-04-02T06:48:39Z