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

sample mappings for scd1,scd2 and scd3

Question Posted / sujith

Answers were Sorted based on User's Feedback



sample mappings for scd1,scd2 and scd3..

Answer / vemuri vijay

steps
go to mappings
go to wizards
there is two optins
1.getting started
2.scd
go to scd
again three types
type1
type2
type3
select ur requirement
ex.
take type1
select source table and give name for target table
then
next
give target table fields
then
finish
automatically u will get mapping
go to
workflow manager
create
task and
worklet
start task
thats all

Is This Answer Correct ?    12 Yes 7 No

sample mappings for scd1,scd2 and scd3..

Answer / nikhil tiwari

check this site for SCD-2 step by step implementation:

http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

can we create index and drop index in exsisting table while using infomatica

4 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

how to convert the .doc docs into .txt format using informatica

4 Answers  

What are conformed dimensions?

1 Answers  

how do u move the code from development to production?

3 Answers  

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

For more Informatica Interview Questions Click Here
Categories