Informatica Transformation Properties

Source Qualifier: Active,Connected

Transformation, Ports, Properties, Sources

    Not reusable

1) Ports:Port name,datatype,prec,scale,In,out

2) Properties:SQL query.

3) user defined join.

4) source filter

5) Number of sorted ports.

6) Tracing level

7) Select Distinct

Update Strategy: Active, Connected

 Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out

2)Properties:Update str expression,fwd rejected rows,tracing level

Expression:Passive,Connected

   Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out,var,expression

2)Properties: Transformation attribute-Tracing level

Sequence Generator:Passive,Connected

Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out

2) Properties: start value, Increment by, end value, current value, cycle, number of cached values, reset, tracing level

Aggregator: Active,Connected

  Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out,var,expression,groupby

2)Properties:cache directory,tracing level,sorted input

Filter: Connected,Active

  Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out

2)Properties:Filter condition,Tracing level

Lookup:Passive,Connected and unconnected

  Transformation,Ports,Properties,Condition

1)Ports:Port name,datatype,prec,scale,In,out,Lookup,Return,Associated Port

2)Prop:

Lookup Sql Override-opens Editor

Lookup Table Name,

Lkp caching enabled,

Lkp policy on multiple cache-use first value,use last value,report error,

Lkp condition,

Location information-select database(Source or Target)

Source type,

Recache if state,

Tracing level,

Lkp cache directory name,

Lkp cache initialize,

Lkp cache persistent,

Lkp data cache size,

Lkp index cache size,

Dynamic lkp cache,

Cache file name prefix,

Recache from database.

3)Condition:lookup table column,operator,transformation port

 

Informatica Transformation Properties

Joiner: Connected,Active

  Transformation,Ports,Properties,Condition

1)Ports:Port name,datatype,prec,scale,In,out,Master

2)Prop:

cache sensitive string comparision,

cache directory,

join condition,

join type--Normal join,Master outer join,detail outer join,full outer join-,

Null ordering in master--null is highest value,null is lowest value,

Null ordering in detail--null is highest value,null is lowest value,

Tracing level,

3)Condition:Master,Operator,Detail

Normalizer:Active,Connected

 Transformation,Ports,Properties,Normalizer.

1)Ports:Port name,datatype,prec,scale,In,out,Sequence

2)Prop:Reset,Restart,Tracing level

3)Normalizer:column name,level,occurs,datatype,prec,scale,keytype.

Router:Connected,Active

Transformation,Ports,Properties,Groups

1)Ports:Port name,datatype,prec,scale,In,out

2)Prop:Tracing level

3)Groups:Group name,Group filter condition

Rank:Active,Connected

Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out,var,return,expre,groupby

2)Properties:Cache Directory.Top/bottom,Number of ranks,case sensitive string comparision,Tracing level

Stored Procedure: Passive,Connected and unconnected

Transformation,Ports,Properties

1)Ports:Port name,datatype,prec,scale,In,out,return

2)Prop:Stored Procedure name

connection information--Select database

call text

Stored Procedure type-Target preload,target postload,Normal,source preload,source postload

execution order

Tracing level

Tracing Level: Amount of detail displayed in the session log for this transformation.

The options are Terse, Normal, Verbose Data, and Verbose Initialization