Question { Accenture, 14407 }

whether Sequence generater T/r uses Caches? then what type
of Cache it is

Answer

reusable and non-reusable cache transformation, reusable
will provide unique value for same transformation used in
all sessions.

Question { Chase, 26661 }

What is checksum termnology in informatica? Where do you use
it ?

Answer

Checksum used to cretae unique columns in table when u
implement checsum on any field in table during load time
then it will automatically find the max value of the field
and add 1 for every next record inserted. basically used i
SCD to create Index.

Question { Accenture, 8860 }

Transformer is a __________ stage
option1:Passive
2.Active
3.Dynamic
4.Static

Answer

Dynamic more then active stage because its not taking space
in your DB its initiate run time with session, cashe data
do tranformations and end with session.

Question { CTS, 13861 }

What is a candidate key?

Answer

A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data(unique). Each table may have one or more
candidate keys. One of these candidate keys is selected as
the table primary key else are called Alternate Key.