Answer / deepthi

1.Refreshing of data is possible in materialised views. we
can restrict rows of data for acces from other users in
materialised views.

above mentioned two points are not possible with table.

Thanks
Deepthi

Answer / chandra

TABLE: A TABLE IS HAVING ALL THE COLUMS DATA

WHERE AS

MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

---

Explain transaction control transformation in informatica

0 Answers   Informatica,

---

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

---

without update strategy how to insert &update?

1 Answers   DELL,

---

explan ur project architecture?

0 Answers   TCS,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

---