Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Hi gurus can any one tell me with a flow how to implement SCD
Type 1 and SCD Type 2 in a single mapping.For some fields SCD
type has to be implemented and for some fields scd type has to
be implementd..Thank in advance....

Answer Posted / kiran ghatage

You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a transaction control transformation?

1142


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10629


can we override a native sql query within informatica? Where do we do it? How do we do it?

1012


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

999


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1102


Differences between connected and unconnected lookup?

1123


Explain scd type 3 through mapping.

916


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1845


What is rank transformation?

928


What is a filter transformation and why it is an active one?

905


While migrating the data from one environment to another environment how would you manage the connections?

1046


How many ways are there to create ports?

1234


Slowly changing dimensions, types and where will you use them

1653


How identifying bottlenecks in various components of informatica and resolving them?

1055


What do mean by local and global repository?

1150