What is the difference between a table and the materialized
view?
Answer Posted / 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
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain lookup transformation source types in informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Could you explain what is enterprise data warehouse?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you promote a non-reusable transformation to reusable transformation?
What is an unconnected transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain the informatica workflow?
Explain what are the different versions of informatica?
What is expression transformation?
What is rank index in rank transformation?
Partition, what happens if the specified key range is shorter and longer
What is primary and backup node?
In how many ways we can create ports?