Answer Posted / venkat8510

Please follow the below, that would be helpful.

https://www.bullraider.com/database/informatica/scenario/101-informatica-scenario35

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

---

What is depict expression change?

1120

---

draw informatica architecture 8.6 ?

3871

---

What is flashback table ? Advance thanks

1936

---

How to generate sequence numbers?

1088

---

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.

2860

---

what are the deliverables?in your project?

2152

---

Tell me about MD5 functions in informatica

929

---

What is the difference between a connected look up and unconnected lookup?

966

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

---

What are ETL Tools?

1118

---

How can we use mapping variables in informatica?

1063

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

---

What is a passive transformation?

1104

---