Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

---

What is blocking transformation?

0 Answers   Informatica,

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---