✍ Kashif M
Trends

Sunday, 3 August 2014


Informatica Transformation Properties


By on August 03, 2014

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
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

Kashif
mkashu: Informatica Transformation Properties
Review : Kashif | Kashif
Update: August 03, 2014 | Rating: 4.5

Comment for "Informatica Transformation Properties"

1 comments:

  1. There are few more transformations try to add remaining also

    ReplyDelete