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,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

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

0 Answers   Keane India Ltd,

---

What is dynamic cache?

0 Answers  

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

Write the program through which the records can be updated?

0 Answers  

---