What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

What is the Difference between sorter and aggregator?

2 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---