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
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain load alternative records / rows into multiple targets - informatica
Explain how to import oracle sequence into informatica?
What can we do to improve the performance of informatica aggregator transformation?
Enlist some properties of sessions.
What is meant by lookup transformation?
How to do unit testing in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How can we remove the duplicates from flat file source?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Partition, what happens if the specified key range is shorter and longer
What is the function of union transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how