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 |
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain what is the data type of the surrogate key?
What are the primary ways to store data in OLAP?
Explain dimensional modelling?
What is a Decision Tree Algorithm?
What is data validation strategies for data mart v?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Explain what is metadata reporter?
Explain bus schema?
What is Drill by? drill through?
What is the difference between Datawarehouse and OLAP?
Explain how to get the first 100 rows from the flat file into the target?