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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is difference between query studio and report studio?

545


Explain what are fact, dimension, and measure?

550


Whether dimension table can have numeric value?

598


What is the difference between power center and power mart?

553


What are the different types of segments?

545






What are Aggregate tables?

684


what are the major three types of modeling used?

618


Explain what is metadata reporter?

566


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5262


Why should we use data ware housing and how can you extract data for analysis with example?

555


Explain what are the methodologies of data warehousing?

530


What are the mapping paramaters and maping variables?

566


What are the advantages of query studio compared to report studio?

499


What is vdl (view definition language) explain?

637


i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1585