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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is different between sequential batch and concurrent batch and which is recommended and why?

4966


what is an ETL or ETT? And what are the different types?

7560


What are cubes and olap cubes?

1041


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1052


What are the differences between sql override and update override?

1142


can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1862


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4172


what are the data modeling tools you have used?(polaris)

2046


What is staging area referring to?

1209


how to connect to a flatfile through ftp in informatica

14381


What is meant by incremental load?

1157


What is a materialized view log?

1042


What is initial load and what is full load?

1047


where is the cache (lookup, index) created and how can you see it.

2064


what is pmrep command?

11650