Answer Posted / bsgsr

using the informatica schedular tool or third party tools
like control m, maestro, tivoli etc. if wrong sorry

State the differences between sql override and lookup override?

1133

---

Explain the aggregator transformation?

1109

---

What is the command used to run a batch?

1014

---

What is meant by lookup transformation? Explain the types of lookup transformation?

908

---

How to delete duplicate row using informatica?

996

---

wat are deployement groups in informatica, how it will be used for developers

1685

---

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?

2223

---

what is degenerated dimension?

3895

---

What is data transformation manager process?

1100

---

tell me about your project functionality

2309

---

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.

2822

---

What are the new features of informatica 9.x at the developer level?

999

---

What is update strategy transform?

1040

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2139

---

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

1036

---