Answer Posted / srinu

In support -
Jobs Scheduling,
Long running jobs Perfomece tune,Daily SLA time,
New requiment changes in existing code,
Data validation,,, Mainly errors under one of the cause.

Clint will ask you directly - Come up with possible
solutions to over come the error.

Different qualification between a related rotate toward the sky and isolates look upward?

931

---

What is the session task and command task?

994

---

Briefly define reusable transformation?

1077

---

According to his methodology what all you need before you build a datawarehouse

1691

---

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.

1645

---

Please let me know how to make encryption and decryption with example?

1848

---

What are pre and post-session shell commands?

1239

---

What is the meaning of decode in informatica?

1076

---

What is meant by lookup transformation?

1034

---

What do you mean by enterprise data warehousing?

1002

---

What are Dimensional table?

1001

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7318

---

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?

2210

---

Can u generate reports in Informatica?

1026

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1840

---