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
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain the difference between a data warehouse and a data mart?
As union transformation gives UNION ALL output, how you will get the UNION output?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a transaction control transformation?
What is the need of etl tools?
What is complex mapping?
What are the types of lookup transformation?
What is sq transformation?
Performance tuning( what you did in performance tuning)
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
In informatica workflow manager, how many repositories can be created?
What is workflow? What are the components of the workflow manager?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.