GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica

 Print  |  
Question:  What r the reusable transforamtions?


Answer: Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances automatically reflect these changes.This feature can save U great deal of work.



January 01, 2006 02:25:22 #1
 Sithu Database Expert  Member Since: December 2005    Total Comments: 161 

RE: What r the reusable transforamtions?
 

A transformation can reused, that is know as reusable transformation

 

You can design using 2 methods

  1. using transformation developer
  2. create normal one and promote it to reusable

 

Cheers

Sithu

     

 

Back To Question