Answer Posted / mrugesh

Hi Mukesh,

Can u send me the study guide & dumps to my mail id:

mrugeshparikh@yahoo.com

Thanks!

What are ETL Tools?

1170

---

Define the various join types of joiner transformation?

1039

---

Explain the tuning lookup transformation - informatica

1043

---

How to start a workflow using pmcmd command?

1306

---

Reusable transformation and shortcut differences

1880

---

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

---

How to use procedural logic inside infromatica?

1320

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1138

---

What is data movement mode in Informatica and difference between them?

1181

---

Define joiner transformation?

1101

---

What is a pre-defined event and user-defined event?

1079

---

Write the prerequisite tasks to achieve the session partition?

1226

---

Explain the difference between a data warehouse and a data mart?

1108

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7586

---

If informatica has its scheduler why using third party scheduler?

1303

---