Answer Posted / achoudhr

Thanks for your reply.

Differences between connected and unconnected lookup?

1224

---

What are the prerequisite tasks to achieve the session partition?

1263

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1288

---

What are the different types of transformation available in informatica.

1108

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2086

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1685

---

What are the components of Informatica? And what is the purpose of each?

1063

---

How to differentiate between the active and passive transformations?

1175

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7265

---

What is a surrogate key?

1091

---

When do you use sql override in a lookup transformation?

1105

---

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.

2865

---

In informatics server which files are created during the session rums?

1125

---

Do you find any difficulty while working with flat files as source and target?

1106

---

What is sequence generator transformation in informatica?

1086

---