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 |
What is the different lookup cache(s)?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
What are parallel querys and query hints?
What are the transformations that are not supported in mapplet?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
how to run the batch using pmcmd command
What are the types of data that passes between informatica server and stored procedure?
what is metadata?
What does update strategy mean, and what are the different option of it?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,