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

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

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  

---

In warehouses how many schemas are there?

0 Answers  

---

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

4 Answers  

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---