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 |
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
what is dynamic cashe
Define error Threshold?
What is aggregate cache in aggregator transforamtion?
How many ways are there to create ports?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
What is the Hierarchy of DWH?
how to duplicates from expression transformation without using sorter before that
SO many times i saw "$PM parser error " .what is meant by PM?