How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / ankit kansal
Transformation in Informatica are set of components which have some specially defined functionality which is used to transform the data as per business needs.
1)Sorter-To sort the data.
2)Expression-heavily used to transform data type and perform several business logics
3)Aggregator
4)Rank ..e.t.c
deepinopensource.blogspot.in
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the definition of normalized and denormalized view?
Do you view contain data?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain the difference between keylokup and joiner?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain what is power center repository?
Explain normalization?
Explain what is data validation strategies for data mart validation after loading process?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is the goal of optimizer?
Difference between cold fusion 5 and cold fusion mx 6?
What is index awareness in universe?
Is union transormation is active transformation?
What is the use of dimensional modeling in data warehousing?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?