What is the difference between view and materialised view?
Answer Posted / yaseen
Rowid of view and table is same
Rowid of M.view and table is different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
Explain how many types of dimensions are available in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the Process to creating lookup transformation in informatica
What is meant by active and passive transformation?
Different sorts of metadata that stores in the storage facility?
How to join three sources using joiner? Explain though mapping flow.
What is substr in informatica?
What is enterprise data warehousing?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain constraint based loading in informatica
Does an informatica transformation support only aggregate expressions?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is target designer and target load order?