Answer Posted / sourav

Hi Mukesh,

My name is Sourav. Kindly mail me the dumps for "Informatica Certified Designer" at karmakarsourav09@yahoo.in.

Thanks,
Sourav

What are the tasks that can be performed using sq?

1026

---

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

2435

---

How can we create index after completion of load process?

1073

---

What is a router transformation?

1050

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1109

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1645

---

Enlist the various types of transformations.

955

---

How to do unit testing in informatica?

1125

---

what is size of u r database?

2251

---

What do think which one is the better joiner or look up?

1144

---

What is the reusable transformation?

1008

---

Can we create multiple integration service on single repository?

1134

---

Explain what is informatica metadata and where is it stored?

989

---

What are roles and groups and benefits of using them?

993

---

What is a code page?

1118

---