A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

In Which scenario did u used Incremental loading?

2 Answers  

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---