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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

enterprise datawarehouse your project phase by phase
explain?

Question Posted / dinesh006


enterprise datawarehouse your project phase by phase explain?..

Answer / siva

Its depend on the project scheduling..

In some projects.. it will considered as
ph1 -- Requirements Gathering
ph2 -- Analysis and framework
ph3 -- Designing
ph4 -- Production Migration, performance tuning and
maintenance activities

In other hand some projects will be set as
ph1 -- Integrating the sources
ph2 -- Creating the Datamarts and Aggregations
ph3 -- Reporting

So its depends on size and requirements of the project

Hope you got it..

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Informatica Interview Questions

Is stop and abort are same in informatica?

0 Answers  

How can you validate all mappings in the repository simultaneously?

0 Answers  

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

When do you use mapping parameters? (In which transformations)

1 Answers  

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

What are the ETL tools available in DWH?

6 Answers   Mphasis,

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

How will you update the row without using update statergy?

10 Answers   CTS,

What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

For more Informatica Interview Questions Click Here
Categories