what are the different types of transformation available in
informatica and what are the mostly used ?
Answers were Sorted based on User's Feedback
Answer / guest
Procedure,Sequence generator and joiner.
The mostly used transformations are :
Lookup, Expression, Agreegator,Router and Update
Strategy,joiner and sequence generator.
|Is This Answer Correct ?||20 Yes||5 No|
Answer / sailaja
strategy ,joiner,router,filter,sequence generator,
aggregator,normalizer,stored procedure, webservice
transformation,XML generator, XMLparser,source qualifier
Mostly used transformations are
1.Look up, Expressions
|Is This Answer Correct ?||8 Yes||0 No|
Answer / bharathi
Procedure,Sequence generator and joiner,Update
Strategy,Normalizer,XML source qualifier.
|Is This Answer Correct ?||5 Yes||6 No|
what are surrogate keys?
what is data driven?
design of staging area?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different types of repositories created using informatica?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
daily how much amount of data send to production?
What is the difference between a connected look up and unconnected lookup?
How can you increase the performance in joiner transformation?
What is powercenter on grid?
From where we can start or use pmcmd?
in which situations do u go for starflake schema ?