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)

How do you migrate data from one environment to another?

1148

---

What does reusable transformation mean?

1193

---

How many input parameters can exist in an unconnected lookup?

1601

---

What is exclusive and normal mode for repository services?

1189

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8264

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2599

---

What are the different types of olap? Give an example?

1096

---

Is it possible to create multiple domains on a single Informatica server?

1289

---

What is joiner transformation?

1067

---

define galaxy repository in informatica

2286

---

What is informatica etl tool?

1060

---

How can we remove the duplicates from flat file source?

1075

---

Why do we need informatica?

1054

---

Which are the different editions of informatica powercenter that are available?

1080

---

How an expression transformation differs from aggregator transformation?

1088

---