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)

Explain about Informatica server process that how it works relates to mapping variables?

1029

---

Did u used latest transformations of 8.6.0? for what?

1843

---

What is a joiner transformation?

950

---

what is song in infrmatica...?

2185

---

Tell me about Propagate functions in informatica

890

---

permutations of mapplet

2473

---

What are pre and post-session shell commands?

1256

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2487

---

difference between informatica 8.1.1 and 8.6

3644

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2002

---

what is informatica metadata?

991

---

What are ETL Tools?

1064

---

Explain the different kinds of facts.

948

---

What the difference is between a database, a data warehouse and a data mart?

1104

---

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

1870

---