Re: What are the types of lookup caches?

Answer Persistent cache: yoU can save the lookup

# 1 cache files and
reuse them the next time the informatica
server processes a
lookup transformation configured to use the
cache.

Recache from database: If the persistent

cache is not
synchronized with he lookup table, yoU can
configure the
lookup transformation to rebuild the lookup
cache.

Static cache: U can configure a static or

readonly cache for
only lookup table. By default informatica
server creates a
static cache. It caches the lookup table and
lookup values
in the cache for each row that comes into the
transformation. when the lookup condition is
true, the
informatica server does not update the cache
while it
prosesses the lookup transformation.

Dynamic cache: If you want to cache the

target table and
insert new rows into cache and the target,
you can create a
look up transformation to use dynamic
cache.The informatica
server dynamically inerts data to the target
table.

shared cache: yoU can share the lookup cache

between
multiple transactions.yoU can share unnamed
cache between
transformations inthe same maping.
Data Modeling
- A technique for describing information structures and capturing information
requirements, policies and rules

Data Model
- A specification of data structures and business rules.

Data Model Types

Logical
- Conceptual
- Key Based
- Fully Attributed
Physical
- Transform
- RDBMS Schema

Logical Data Model

- specification of the data structures and business rules needed to support the business
area
- technology independent

Physical Data Model

- a solution to the logical data model requirements
- technology dependent

Data Model Components

- Entity
- Attribute
- Relationship

Entities
- Abstractions of real world things
- Any distinguishable person, place, thing, event or concept about which information is
kept
- A collection of like things called instances
- An instance is a single occurrence of an entity

Types of Entities
- Independent Entity
- Dependent Entity
- Characteristic Entity
- Associative Entity
- Super-type Entity
- Sub-type Entity

Independent Entity
- Does not depend on any other for its identification
- rectangular box

Dependent Entity
- Depends on one or more other entities for its identification (The primary key contains
foreign keys)
- rounded box

Characteristic Entity
- A group of attributes that occurs many times for an entity, and is not directly identified
by any other entity; a dependent entity with only one identifying parent.
Associative Entity
- an entity that inherits its primary key from two or more other entities (those
associated)

Super-type Entity
- The top of any level of a sub-type hierarchy

Sub-type Entity
- a subset of the instances of a super-type entity that share common attributes or
relationships distinct from other subsets. The sub-type entity inherits all of the properties
of the generic parent.

Attributes
- The properties of an entity

Types of attributes:
- Primary Key
- Primary Key Attributes
- Candidate Key
- Alternate Key
- Inversion Entry
- Non-key Attribute

Primary Key
- An attribute or group of attributes chosen as the unique identifier of an entity

Primary Key Attribute

- Forms the primary key either by itself or in combination with other primary key
attributes

Candidate Key
- an attribute or group of attributes possibly chosen as a primary key

Alternate Key
- a candidate key not chosen as the primary key

Inversion Entry
- an attribute or group of attributes frequently used to access the entity but may not
result in finding exactly one instance

Non-Key Attribute
- an attribute not chosen as part of the primary key of the entity

Relationships
- A connection between two entities
- IDEF1X relationships are binary--connecting exactly two entities.

Relationship Types
- Identifying
- Non-Identifying
- Non-Specific

Identifying
- primary key attributes of the parent entity become part of the primary key of the child
entity
Non-Identifying
- primary key attributes of the parent entity become part of the non-key attributes of the
child entity

Nonspecific
- a presentation style relationship contributing no foreign keys and relating many of one
entity to many of another entity; allowed only in entity relationship diagrams

Cardinality
One to Zero or Many Identifying
One to One or Many Identifying
One to Zero or One Identifying
One to Exactly N Identifying

One to Zero or Many Non-identifying

One to One or Many Non-identifying
One to Zero or One Non-identifying
One to Exactly N Non-identifying

Zero or One to Zero or Many Optional

Zero or One to One or Many Optional
Zero or One to Zero or One Optional
Zero or One to Exactly N Optional