Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

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

6 Answers   HP, TCS,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

what is junk dimension

4 Answers   Cap Gemini,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

What is meta data and system catalog?

2 Answers  

---

what is dynamic cashe

3 Answers   Informatica,

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---