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 |
What is the difference between filter and lookup transformation?
Explain me what are conformed dimensions?
I know of using applysimple, but there are other ways too?
What are the different ways to represent the loading of dimension tables?
Why denormalization is promoted in universe designing?
What is ?Data mining??
Explain what are data marts?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain about core dimension, balanced dimension, and dirty dimension?
What are aggregate tables and aggregate fact tables?