Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of transformation available in
informatica and what are the mostly used ?
- 3 Answers
- 25124 Views
- TCS, I also Faced
- E-Mail Answers
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 |
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
What are the different options available for update strategy?
write a query to retrieve the latest records from the table sorted by version(scd)
Where do you create/define mapping parameter and mapping variable?
In which scenario did you used pushdown optimization?
What is the difference between writing a joiner query in ANSI style and THETA style?
can we use self join in informaitca?
What are the restrictions of union transformation?
why do we go for update strategy tr in SCD rather using the session properties?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Informatica and datawarehousing courses in Pune?
Teradata 
