SCD TYPE 2 :--- Effective date range

SCD TYPE 2 :--- Effective date range

Posted in the Informatica Forum

Since: Aug 07

Visakhapatnam, India

#1 Aug 6, 2007
i'm new to informatica nd new to this site can any body send me the example nd mapping of the scd type 2 effective date range

Singapore, Singapore

#2 Nov 29, 2007
For your reference follow the example which is there in the Informatica help.Tq


#3 Sep 21, 2009
hi, what is the logic that is used in scd2 using lookup and expression transformation even if slightest change appears in the source that will be treated as inserted now, how to implement this give with an example

Hyderabad, India

#10 Jan 26, 2011
it very good

Richmond Hill, Canada

#12 Feb 12, 2011



Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
Loading a specific Erwin model version into Met... Apr 13 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... Mar '16 anil 1
Update Records Feb '16 beginer_informatica 1
First and last rec from flat file to table Feb '16 Nan 1
active and passive t/f Feb '16 Nan 1
Informatica PowerCenter SAML Support Feb '16 Steve 1
More from around the web