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

0 Answers  

---

How can you access the remote source into your session?

1 Answers  

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

What is deployment group?

0 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

---

Do you have knowledge in ralph kimball methodology

1 Answers  

---