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 needs to be done when the database is shutdown?

0 Answers  


What is the difference between drill through and masterdetail reports?

0 Answers  


Which columns go to the fact table and which columns go the dimension table?

0 Answers  


What is data mart in data warehouse?

0 Answers  


What is a linked cube?

0 Answers  






Which are the olap tools available that are supported by oracle?

0 Answers  


Explain how many ways you create ports?

0 Answers  


What is a hash cluster?

0 Answers  


Explain in simple terms, the concept of Data Mining.

3 Answers  


Explain what is ods (operation data source)?

0 Answers  


What is Analysis Services?

0 Answers  


what are the types of dimension tables

19 Answers   Infotech,


Categories