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.

0 Answers   IBM,

---

What is flashback table ? Advance thanks

0 Answers   Puma,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

What is a surrogate key?

0 Answers  

---

where to select code page option?

2 Answers   TCS,

---

---

What is the difference between a repository server and a powerhouse?

0 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   Deloitte, TCS,

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---