Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 3 August 2014

Informatica Transformation Properties

By on 10:14:00

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
1)Ports:Port name,datatype,prec,scale,In,out
2)Properties:Update str expression,fwd rejected rows,tracing level

1)Ports:Port name,datatype,prec,scale,In,out,var,expression
2)Properties: Transformation attribute-Tracing level

Sequence Generator:Passive,Connected
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
1)Ports:Port name,datatype,prec,scale,In,out,var,expression,groupby
2)Properties:cache directory,tracing level,sorted input

Filter: Connected,Active
1)Ports:Port name,datatype,prec,scale,In,out
2)Properties:Filter condition,Tracing level

Lookup:Passive,Connected and unconnected
1)Ports:Port name,datatype,prec,scale,In,out,Lookup,Return,Associated Port
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
1)Ports:Port name,datatype,prec,scale,In,out,Master
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,

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.

1)Ports:Port name,datatype,prec,scale,In,out
2)Prop:Tracing level
3)Groups:Group name,Group filter condition

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


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



1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)