Answer Posted / pradeep

1)Alternative to updated strategy,we can with target update override. US works based primaray key constrainst where as target updated override works without primary key constraints.

2)When you configure session with Normal load,the integration service performs record by record as a result IS can capture commit points and it enables the session recovery.

The IS capture commits points from database log and saves in repository

3) The lookup transformation genrates the sql qurey,query contains select,group by,order by.we can override default query by specifying the order by clause

What is decode in static cache?

1261

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1127

---

Is it possible to use a client with different version than that of its Informatica server?

1189

---

What is the meaning of up gradation of repository?

2052

---

What do you mean by filter transformation?

1003

---

Can we override a native sql query within informatica?

1088

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2151

---

What does cheating measurement mean?

1105

---

Design time, run time. If you don't create parameter what will happen

1892

---

What will be the approach?

1037

---

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

1199

---

What are the guidelines to be followed while using union transformation?

1206

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2795

---

What is fact table? Explain the different kinds of facts.

1123

---

What are the mapping parameters and mapping variables?

1272

---