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 / sajj

If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

How many steps etl contains explain with example?

0 Answers  


What do you understand by the term ‘transformation’?

0 Answers  


What is the difference between round-robin partitioning and hash partitioning?

0 Answers  


How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  


we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  


WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,


flat filevalidation in informatica

0 Answers   Hewitt,


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

0 Answers  


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


Explain the difference between etl tool and olap tools?

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,


How many steps etl contains?

0 Answers  


Categories