Answer Posted / isha

Dont select the option of making value persistant

What differs when we choose the sorted input for aggregator transformation?

1070

---

Briefly explain the aggregator transformation?

1063

---

What is a connected transformation?

1182

---

What are the features of complex mapping?

1202

---

What is data movement mode in Informatica and difference between them?

1180

---

Slowly changing dimensions, types and where will you use them

1767

---

Why union transformation is an active transformation?

1099

---

What is meant by query override?

1112

---

What are session parameters ? How do you set them?

1899

---

Parameter and variable differences

2105

---

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.

2899

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1555

---

Explain the types of transformations?

1097

---

which one is better performance wise joiner or look up

1149

---

what is the difference between informatica6.1 and infomatica7.1

2359

---