Answer Posted / srikanth

select count (*), deptno from emp group by deptno having
count(*)>10;

What is meant by target load plan?

974

---

What are the popular informatica products?

1015

---

What is the difference between informatics 7x and 8x and what is latest version?

1085

---

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.

2361

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6493

---

What are the static cache and dynamic cache in informatica?

1195

---

What is meant by active and passive transformation?

1126

---

Explain what is informatica metadata and where is it stored?

1051

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1079

---

Enlist the advantages of informatica.

1068

---

update strategy transformation in informatica

1068

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7188

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

design of staging area?

2030

---