How can you define a transformation? What are different
types of transformations in Informatica?

Answers were Sorted based on User's Feedback



How can you define a transformation? What are different types of transformations in Informatica?..

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

How can you define a transformation? What are different types of transformations in Informatica?..

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

How can you define a transformation? What are different types of transformations in Informatica?..

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

How can you define a transformation? What are different types of transformations in Informatica?..

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

How can you define a transformation? What are different types of transformations in Informatica?..

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

How can you define a transformation? What are different types of transformations in Informatica?..

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

How can you define a transformation? What are different types of transformations in Informatica?..

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

Post New Answer

More Data Warehouse General Interview Questions

What are aggregate fact tables ? why they are needed? give an example

2 Answers  


Explain what is a view as it relates to system modeling?

0 Answers  


Explain what is the data type of the surrogate key?

0 Answers  


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

0 Answers  


Explain vldb?

0 Answers  






What is Time Series algorithm in data mining?

2 Answers  


Best Data Ware housing training institute in delhi

3 Answers  


What is data type of the surrogate key?

0 Answers  


Hierarchy of DWH?

2 Answers   Accenture, EDS, IBM, iFlex, TCS,


Can we take backup when the database is opened?

0 Answers  


When should one use an MD-database (multi-dimensional database) and not a relational one?

2 Answers   IBM,


What is cost benefit analysis (cba)?

0 Answers  


Categories