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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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...

Question Posted / hemanth

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2681

How to use procedural logic inside infromatica?

1138

How can you validate all mappings in the repository simultaneously?

1290

Suppose we do not group by on any ports of the aggregator what will be the output?

985

tell me 5 session failure in real time how can you solve that in your project?

2187

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1997

What is rank transformation?

932

Differentiate between sessions and batches?

965

COM components can be used in Informatica

2315

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1853

 Informatica Checkpoints

3273

What is the format of informatica objects in a repository?

976

What are the measure objects?

1120

Which are the different editions of informatica powercenter that are available?

971

whats the logic to load the lower level of granularity of data to fact table.

2208