Answer / nagarjuna

Two mapping wizards are there.

1. Simple pass through
2. slowly changing dimensions

Answer / swetha

The Designer provides two mapping wizards to help you create
mappings quickly and easily. Both wizards are designed to
create mappings for loading and maintaining star schemas, a
series of dimensions related to a central fact table.
Getting Started Wizard. Creates mappings to load static fact
and dimension tables, as well as slowly growing dimension
tables. Slowly Changing Dimensions Wizard.

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

Why is sorter an active transformation?

0 Answers  

---

What are the two modes of datamovement in informatica sever?

2 Answers  

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

How the Informatica Server reads perameter file?

1 Answers  

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---