Informatica - I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup tran

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 42 of 301

I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example...

Total Answers and Comments: 2

Last Update: August 07, 2006 Asked by: kalpana

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi

Explain about TNSPING

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID. Open Command prompt. Write tnsping < SID for the database connectivity you want to check > If you get the message “Used TNSNAMES

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

UML Elements : Sequence Diagram

UML Elements Sequence Diagram In the Unified Modeling Language the sequence diagram is the name that has been given to the Message Sequence Chart The sequence diagram will be responsible for showing various processes or elements that exist together simultaneously and it will often be represented by

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

How Data Is Stored Within a Data Warehouse

How Data Is Stored Within a Data Warehouse The data that is stored in the data warehouse is just as important as the data warehouse itself Having a fundamental understanding of how this data is stored can be useful in the successful implementation and utilization of a data warehouse One term that yo

SQL Server Stored Procedures

In this tutorial you will learn further more about Access and Manipulate SQL Server data Using Stored Procedures Creating a Stored Procedure Running Stored Procedures from NET Using Parameters in Stored Procedures The IDENTITY Variable Access and Manipulate SQL Server data Using Stored Procedures mo

SQL Server 2000: Using System and Extended Stored Procedures

This tutorial covers how to use System Stored Procedures which are stored in master and msdb databases and normally begin with sp and Extended Stored Procedures normally begin with xp Using System Stored Procedures mosgoogle Whenever you add a database add a login create a table or modify any

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

Informatica FAQ Related

—