SCD Mappings are mosltly used Unconnected Lookup Transformation. Unconnected Lookup used static Cache only.At this time how can u insert or update date in Target by using static cache?






There r 3 types of dimensions
1.star schema
2.snowflake schema
3.glaxy schema
3 types.That are
1. SCD(slowly changing dimension) type1
2. SCD type2
3. SCD type3

No comments:

Post a Comment