Answer Posted / urs

1) Following are the some of bottlenecks in informatica..

(i) source bottlenecks
(ii)Target bottlenecks
(iii)Mapping bottlenecks
(iv) system bottlenecks

3)Informatica is one of most popular ETL tool...it will extract the data from the different sources and it will transform the data as per business logic and then it will load the data into different targets..

I have a flat file, want to reverse the contents of the flat file

905

---

What is domain and gateway node?

925

---

what is the hint? how to use it to reduce the query processing in program?

7104

---

Explain the difference between a data warehouse and a data mart?

798

---

What is dimensional table?

799

---

What is the need of etl tools?

828

---

How can we use mapping variables in informatica?

788

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2102

---

What is joiner change?

909

---

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?

1427

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1462

---

Can informatica load heterogeneous targets from heterogeneous sources?

942

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

822

---

Could you explain what is enterprise data warehouse?

757

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

907

---