#ERWIN DATA MODELING INTERVIEW QUESTIONS HOW TO#

A local view is not exportedĮntity view - A selection of attributes from a single occurrence of an entity One execution of a process or procedure step. Local view - Information about an entity that is used completely within Only group views can be identified as repeating. Group view - A collection of entity views, other group views, or both. To define an information which is needed by a process or a Procedure but which is not contained in any of the entities defined for the model. Work view - To define an attribute like counters, subscript, which do not come From entity. A transient view may be an import, export, or local view. Is released at the end of the action block where it was READ.Ī view that represents a piece of data and can be modified by MOVE and

View to an action block that performs an UPDATE action. This means that a procedure step can perform a READ and pass the persistent Once read, a persistent view may be passed to subordinate action blocks. Use WHERE clause with READ and READ EACH actions otherwiseĭB2 will have to scan the entire table for returning the rowsģ) How will you debug the online/batch IEF system?Ĥ) What are persistent views and what are their significance?.Ī view that supports entity actions and represents an entity occurrence.Ī persistent view may be an import, export, or entity action view. Do not use EXPORT views in action blocks when not neededĦ. View matching: same structure on both sidesĤ.

#ERWIN DATA MODELING INTERVIEW QUESTIONS HOW TO#

1) What happens when the subscript of a repeating group view set to zero?Ģ) How to make the code(process) more efficient (performance wise)?ģ.

Erwin data modeling interview questions