How can you define a transformation? What are different
types of transformations in Informatica?
- 7 Answers
- 8871 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Which component has onread method and what it is used for?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain which columns go to the fact table and which columns go the dimension table?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is operational data source (ODS)?
How do you define data block size?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain reference cursor?
What is Active Datawarehousing?
Best institute for MS BI training in Hyderabad, India?
What are different stages of ?Data mining??
Give some difference between oltp and olap.
Teradata 
