What is the difference between view and materialised view?

4 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

what is correlated query?

2 Answers   IBM,

---

Where can we find the throughput option in informatica?

0 Answers  

---

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

---

how tokens will generate?

0 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---