Answer Posted / naveen

Hi

Please refer below mention URL, you will get the complete information about SCD.
http://informaticatutorials-naveen.blogspot.in/2011/04/scd-type-1.html#axzz1qxbPamNm

Regards,
Naveen

How many input parameters can exist in an unconnected lookup?

1604

---

Name the different lookup cache(s)?

1294

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1098

---

What are the advantages of using informatica as an etl tool over teradata?

1077

---

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

1126

---

How might one distinguish in the case of mapping is right or not without associating session?

1197

---

Explain what is informatica metadata and where is it stored?

1109

---

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

1193

---

How can we handle two sessions in informatica?

1094

---

What are some examples of informatica etl programs?

989

---

How we can create indexes after completing the loan process?

1252

---

Briefly explain the aggregator transformation?

1068

---

Differentiate between sessions and batches?

1070

---

How do you change a non-reusable transformation to reusable transformation?

1046

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2128

---