what are the different types of transformation available in
informatica and what are the mostly used ?

Answers were Sorted based on User's Feedback



what are the different types of transformation available in informatica and what are the mostly us..

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

what are the different types of transformation available in informatica and what are the mostly us..

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

what are the different types of transformation available in informatica and what are the mostly us..

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

Post New Answer

More Informatica Interview Questions

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,


What is parallel processing in informatica?

0 Answers  


wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,


i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,


what is lookup chache?

1 Answers   Patni,






How many repositories can we create in Informatica?

3 Answers  


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  


Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,


What is source qualifier transformation?

1 Answers  


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,


Categories