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


how do u decide whether u need to do aggregations at
database level or at Informatica level?



how do u decide whether u need to do aggregations at database level or at Informatica level?..

Answer / chintan thakkar

It should always be done at SQ level, that will improve the performance of the mapping since informatica stores a cache for aggregator transformation.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  


architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

1 Answers   IBM, Infosys,


Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,


Difference between flat files and relational sources?

2 Answers  


Two default user groups created in the repository are____and_____.

0 Answers  


what are the facilities provided by data warehouse to analytical users?

0 Answers  


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,


Difference between flat files and relational sources?

0 Answers   Satyam,


When do we go for the tools in the market?

0 Answers  


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  


what is a worklet?

0 Answers  


Can u access a repository created in previous version of Informatica?

1 Answers  


Categories