Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

What is parameter file?

2 Answers  

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

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  

---

Can you create a flatfile target

3 Answers   ABC,

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

what is materialized view?

2 Answers  

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---