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...

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?

Answer Posted / talluru.sankar naidu

we can use SQ transformation write the query we get ans


select sun(sal) from emp where deptno=10 and deptno=5;



I think its correct

Is This Answer Correct ?    1 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load only null records into target?

1199


What is a joiner transformation and why it is an active one?

1065


Describe data concatenation?

1063


Enlist the tasks for which source qualifier transformation is used.

1024


What is the use of code page?

1070


What if the source is a flat-file?

1090


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1989


what is index?how it can work in informatica

2030


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2167


Explain how to import oracle sequence into informatica?

992


What are roles and groups and benefits of using them?

1045


where to store informatica rejected data? How to extract the informatica rejected data?

988


What is a rank transform?

1074


What is data caches/ index caches?

1067


What is the commit type if you have a transaction control transformation in the mapping?

1022