How can you define a transformation? What are different
types of transformations in Informatica?
Answers were Sorted based on User's Feedback
Answer / guest
transformation is a component in informatica which help us
to transform data from one form to anthor
we have two types of transformation
1, active transformation
2,passive transformation
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / lakshmana rao
A Transformation is a process which recieves inputs and
transform into a desired output.
Two types of transformations.
1.Active Transformation
2.Passive Transformation
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mohd atif
Transformation is defined as modulating the information.
There are two types of Transformation of information
1.Active
2.Passive
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rahul
a transformation basically is a mechanism which enables
transforming the data as per the business requirement.
for eg in the source database if the date is in the mm dd
yyyy format and in the target database the date is in dd mm
yyyy format,so we apply transformation to remove the
inconsistancy
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / kallu bhai
Transformation is object,which can be used to devolop the
business logic for processing tha data.two types of
transformations is there.
1.active transformation
2.passive Transformation
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pk
There is a free lesson on the Informatica aggregator
transformation on the home page of trainovation.com
| Is This Answer Correct ? | 1 Yes | 3 No |
Where the cache files stored?
OLAP architecture?
What is an error log table in informatica occurs and how to maintain it in mapping?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is the difference between olap and datawarehosue?
Can you pass sql queries in filter transformation?
What are the stages that are required in data warehousing?
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 what is metadata reporter?
Explain what are the different methods of loading dimension tables?
What is freehand sql?
What is the difference between narmal load and bulk load?