Answer Posted / chandrasekar

We have to take same source for both scd type1 and type 2.
First , we can take the router Transformation and create two
groups one is scd type1 and scd type2. With that source we
can implement the both type1 and type 2. If anybody want the
workflows means please mail me.

My mail id is chandranmca2007@gmail.com

Thanks.

What is the reusable transformation?

1031

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7180

---

Which are the different editions of informatica powercenter that are available?

1019

---

Could you explain what is enterprise data warehouse?

1116

---

How would you copy the content of one repository to another repository?

995

---

Partition, what happens if the specified key range is shorter and longer

2481

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5757

---

how to load rows into fact table in data warehouse

1156

---

What is sorter transformation?

1021

---

Explain the difference between mapping parameter and mapping variable?

1018

---

What is meant by lookup transformation?

1084

---

What is domain and gateway node?

1152

---

Explain scd type 3 through mapping.

959

---

Explain target update override in informatica

1096

---

where to store informatica rejected data? How to extract the informatica rejected data?

984

---