Answer Posted / basava

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.

How to do unit testing in informatica?

1227

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1916

---

What is option by which we can run all the sessions in a batch simultaneously?

1189

---

What is a joiner transformation and why it is an active one?

1163

---

What is the sequence generator transformation in informatica?

1262

---

How do you handle two sessions in Informatica

1217

---

How to load a Dimension ? and how to load a fact table?

1458

---

What is an expression transformation in informatica?

1089

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1817

---

State the limitations where we cannot use joiner in the mapping pipeline?

1106

---

What are the types of presistent cache in look up tr.

2104

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1097

---

What is the difference between Active and Passive transformation?

1219

---

generate date / time dimension in informatica

1160

---

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

1199

---