Answer / Priyanka Chauhan

A Workflow Monitor in Informatica is a tool to view the status, history, and performance of running workflows.

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

1 Answers   TCS,

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

1 Answers   IBM,

---

How can a transformation be made reusable?

1 Answers   Informatica,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

What are the different threads in DTM process?

1 Answers  

---

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

Explain Dataware house architecture .how data flow from intial to end?

1 Answers   Keane India Ltd,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---