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
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 28 of 631    Print  
What r the reusable transforamtions?
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.




  
Total Answers and Comments: 3 Last Update: April 12, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sithusithu
 

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



Above answer was rated as good by the following members:
ramonasiraj
January 19, 2006 02:25:22   #1  
sithusithu Member Since: December 2005   Contribution: 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


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
April 01, 2007 06:08:19   #2  
zaki        

RE: What r the reusable transforamtions?

Hai to all friends out there

the transformation that can be reused is called a reusable transformation.

as the property suggests it has to be reused:

so for reusing we can do it in two different ways

1) by creating normal transformation and making it reusable by checking it in the check box of the properties of the edit transformation.
2) by using transformation developer, here what ever transformation is developed it is reusable, and it can be used in mapping designer where we can further change its properties, as per our requirement.


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
April 12, 2007 17:50:55   #3  
devaranr Member Since: April 2007   Contribution: 1    

RE: What r the reusable transforamtions?
1. A reusable transformation can be used in multiple transformations
2.The designer stores each reusable transformation as metada separate from
   any mappings  that use the transformation.
3. Every reusable transformation falls within a category of transformations available in the Designer
4.one can only create an External Procedure transformation as a reusable transformation.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape