Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

why we use stored procedure transformation?

Answer Posted / vas.chiky

for complex results, which we cannot obtain in SQL or from
informatica transformation, we go for procedures.

Also doing the calculation in database level doesnt makes
work load high for our informatica server.

process will be given to database.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why union transformation is an active transformation?

1034


What is meant by LDAP users?

1173


How to do the error handling of if ur source is flatfiles?

1948


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2124


What are the types of caches in lookup? Explain them.

955


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2435


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7358


Define mapping and session?

1016


How to use procedural logic inside infromatica?

1203


What is meant by target load plan?

950


Explain sql transformation in script mode examples in informatica

1108


How do we call shell scripts from informatica?

1084


What is a repository? And how to add it in an informatica client?

1128


Plz can any one say me how to get the informatica certification materials and dumps

2033


design of staging area?

2015