Answer / amar pandey

the major difference is lookup transformation which is
active(returns all the matched rows) in informatica 9.0

Answer / deepika

In informatica 8.6 unconnected lookup transformation returns only one port and in informatica 9 it returns mutiple matched ports.

Answer / ramana

we can select distinct record using union trans in informatica 9x

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

What is lookup transformation?

0 Answers  

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

---

What are the different clients of powercenter?

0 Answers  

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---