GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 274 of 327    Print  
External procedure transformation and Custom transformation
What is the difference between "external procedure transformation" and "custom transformation"?


  
Total Answers and Comments: 2 Last Update: March 04, 2009     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: 3    
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 | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
March 04, 2009 05:34:44   #2  
sarita.harsh Member Since: March 2009   Contribution: 5    
RE: External procedure transformation and Custom transformation
The input and output functions occur separately in Custom Transformation. In External transformation both input and output are done by the external procedure function and its parameter consist of all the ports of the transformation. This is because in Custom transformation the input rows need to be processed before outputting any output as it creates transformation applications such as sorting and aggregation.

The output function is a separate function that you must enter in the procedure code to pass output data to the PowerCenter Server.


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : We can update the target table, by using the update override in target definition. it will update based on non key columns. ...
Latest Answer : Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connections give the appropriate connection where you created ...
Read Answers (4) | 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 (4) | 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
 

Data Transformation

Data Transformation is also known as data scrubbing or data cleansing.  It is the formal process of transforming data in the data resource within a common data architecture.  In this  process the production data is decoded and records are merged from multiple DBMS forma
 

Apache Axis2 - Custom Deployers

Custom Deployers We can deploy a service in many ways. We could deploy a service as an archive file Axis2 default by creating a service using a database or by creating a Web Service using a text file. The idea of custom deployers is to open avenues to support any kind of deployment mechanisms. Axis2
 

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape