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  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 274 of 301    Print  
External procedure transformation and Custom transformation
What is the difference between "external procedure transformation" and "custom transformation"?


  
Total Answers and Comments: 1 Last Update: August 07, 2008     Asked by: fordtaurus 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
August 06, 2008 17:04:10   #1  
phdsong Member Since: August 2008   Contribution: 2    
RE: External procedure transformation and Custom transformation
Both transformations operate in conjunction with procedure your create outside of the Desinger interface to extend PowerCenter functionality. However, for external procedure transformation, you need to use the Transformation Exchange (TX) dynamic invocation interface built into PowerCenter. Using TX, you can create an Informatica External Procedure transformation and build it to an external procedure that you have developed. For custom transformation, you need to develop a procedure which uses the functions described in "Custom Transformation functions".
 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : In Session properties SELECT treat source rows as UPDATE In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ...
Latest Answer : how do you call an oracle stored procedure in Informatica? ...
Read Answers (3) | Asked by : Raju
I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...
Read Answers (2) | Asked by : kalpana
Latest Answer : definatly ...
I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana
Read Answers (6) | Asked by : nayana
Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana
Read Answers (3) | Asked by : nayana
How do i get data in a unconnected lookup transformationi.e if i want to compare customer_id in the source with the customer_id in the unconnected lookup, how can i get the data from the source for the customer_id if it is an unconnected lookupthanksnayana
Read Answers (2) | Asked by : nayana
Hi All,I am loading a flat file into a DB2 database.My Session is succeeded but i am getting an error like this""WRITER_1_*_1> WRT_8229 Database errors occurred: FnName: Bind Parameter -- [Striva ][ODBC DETAIL Driver] DTL-00264 DBAPI Error. DB_DESCRIBE failed for file TCCCATCN.;DTL-01252 DBNTC Initial OPEN CONVERSE failed to location "SYSD", rcs 0/2014/-204.;DTL-02006 SQL prepare error. SQLCODE = -204.; DSNT408I SQLCODE = -204, ERROR: AVIPB.TCCCATCN IS AN UNDEFINED NAME; DSNT418I
View Question | Asked by : Sai
View Question | Asked by : Rema

 Sponsored Links

 
Related Articles

XML Remote Calling Procedure

XML Remote Calling Procedure XML RPC or the XML Remote Calling Procedure is a set of compilations and implementations which allow certain programs to run on complex platforms or operating systems and allows them to make Remote Procedure calls on the Internet The Remote Procedure Calling Protocol use
 

Procedure for getting Scholarships

Procedure for getting Scholarships If you have done a bit of research you are probably well aware of the fact that there is a great deal of money available for scholarships Having said that it is sad to see that so many students graduate from college with lots of students loans when they could have
 

Tutorial 36: MSAS: Creating Custom Rollups

To enable proper aggregation of values along a dimension each member of the dimension needs its own aggregation rule These rules are provided by custom roll up Custom rollup operators provide a simple way of controlling the process of rolling up a member to its parents values Custom rollup operators
 

SQL Server 2000: Securing Your Stored Procedure

This tutorial explains how to secure your stored procedures if you ever need to Procedures resides on the database server in open fashion It means that every body can easily access and view its code Securing Your Stored Procedure mosgoogle Stored Procedures resides on the database server in open f
 

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code Creating Stored Procedure with Input Parameters mosgoogle Input Parameters in Stored Procedures are placeholders for data that the user needs to send
 




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