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 improve the session performance in informatica?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
What is the scenario which compels informatica server to reject files?
what is fact table?
What is the difference between a repository server and a powerhouse?
Make a note of the quantity vaults made in informatica?
Where should yoU place the flat file to import the flat file defintion to the designer?
sample mappings for scd1,scd2 and scd3
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
What are the methods for creating reusable transforamtions?
How to do unit testing in informatica? How to load data in informatica ?