Answer Posted / hari

Hi mukesh,

can you Please post to my mail phkrishna19@gmail.com

Thanks,
Hari

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.

2862

---

How to create a non-reusable instance of reusable transformations?

1135

---

How we can create indexes after completing the load process?

1160

---

How does the aggregator transformation handle null values?

1150

---

Differentiate between a database and data warehouse?

1147

---

What is a repository? And how to add it in an informatica client?

1150

---

What is primary and backup node?

1135

---

How do you load alternate records into different tables through mapping flow?

1874

---

Explain the shared cache and re-cache?

1121

---

What is informatica worklet?

1071

---

What is the use of code page?

1097

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What are the modules in Power Center

1680

---

Explain dynamic target flat file name generation in informatica

1056

---

What are the mapping parameters and mapping variables?

1207

---