Answer Posted / kesava reddy

Using Source Qualifier Trnsformation ,
Explantion:
1.Take 2 Source Qualifier Transformations,and
2.One sq ports connect to Target(Unique Target) then Write
a SQL Query (sqlOverride) ,
SELECT DISTINCT EMPNO,ENAME
FROM EMP;
3.TAKE ANOTHER SQ AND CONNECT TO ALL PORTS TO TARGET,THEN
DEVELOP THE SQLOVERRIDE,
SELECT * FROM EMP WHERE ROWID IN(SELECT ROWID FROM EMP
MINUS
SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME)

Why update strategy and union transformations are active?

991

---

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

910

---

What is the Rank index port in Rank transformation?

1015

---

What are the components of Informatica? And what is the purpose of each?

983

---

What is joiner transformation?

949

---

How to extract sap data using informatica?

987

---

draw informatica architecture 8.6 ?

3822

---

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,

7117

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1109

---

What is meant by pre and post session shell command?

1106

---

Implementation methodology

1657

---

How to call shell scripts from informatica?

938

---

Sequence generator, when you move from develoment to production how will you reset

1943

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2237

---