what are the different types of transformation available in
informatica and what are the mostly used ?
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between Load Manager and DTM?
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.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the different clients of powercenter?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
In development project what is the process to follow for an etl developer from day1
Is there any target staging area in informatica not staging area
Mention some types of transformation?
How might you approve all mappings in the archive all the while?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is an expression transformation?
How to generate sequence numbers?
Describe expression transformation?
What is the way to execute pl/sql script using informatica mapping?
What is Session and Batches?