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 ETL 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..please let me know in case of any concerns...



Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single..

Answer / hemanth

yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.


yes we can do scd type1 and scd type2 in a single mapping
itself when the source is same for both. But with same
source we will never face that situation if so the changes
in source will reflect both scd1 and scd2.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,


How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,


Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


What is a standalone command task?

0 Answers  


what is the gap analysis?

1 Answers  


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


How many ways you create ports?

1 Answers  


diffrence between command task and control task

1 Answers   iNautix,


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,


Categories