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
Lookup,Expression,Rank,Sorter,Agreegator,Update
Strategy,Filter,Router,Source Qualifier,stored
Procedure,Sequence generator and joiner.
The mostly used transformations are :
Lookup, Expression, Agreegator,Router and Update
Strategy,joiner and sequence generator.
sumi..
| Is This Answer Correct ? | 20 Yes | 5 No |
Answer / sailaja
Look up,Expression,update
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
Lookup,Expression,Rank,Sorter,Agreegator,Update
Strategy,Filter,Router,Source Qualifier,stored
Procedure,Sequence generator and joiner,Update
Strategy,Normalizer,XML source qualifier.
| Is This Answer Correct ? | 5 Yes | 6 No |
sample mappings for scd1,scd2 and scd3
What are the options in the target session of update strategy transsformatioin?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What is the difference between a connected look up and unconnected lookup?
what is the difference between mapplet & stored procedure?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
How union transformation is active ?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
What is the difference between procedure and stored procedur?
where to store informatica rejected data? How to extract the informatica rejected data?
what is difference between COM & DCOM?