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 >> Data Stage
  2. Suggest New Category

diff between OLTP and OLAP?
what TOP-DOWN and BOTTOM-UP Approach? which is best?
what are Star Schema and Snow Flake Schema?

Question Posted / subbuchamala

Answers were Sorted based on User's Feedback



diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Sch..

Answer / vijay sampoorna

oltp:
1) oltp has current and upated data
2)it is denarmalized
3)it has detailed data
4)it volatail
5) it is dynamic
OLAP:
1)it has current and histarical data
2) it is normalized
3) it has summarised data
4) it is non volatail
5) it is static
top down aproch;
first construct the enteir d.w.h then devided into data marts
Bottom down Aproch:
1)first build datamarts
2) then we build data where houses
star schema:
one fact table sorunded by one or more demintaion tables is calld star schema
it is use less memory
it performence is fast
it contain data duplicates
Snow-flake Schema:
one fact table soround by one or more demintion table that tables can splited into n dimentinos

Is This Answer Correct ?    1 Yes 0 No

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Sch..

Answer / 8686865797

OLTP databases are highly Normalized relational databases & OLAP databases are highly De normalized.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

Define Routines and their types?

0 Answers  

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,

whom do you report?

0 Answers   NTT Data,

What is the difference between server job and parallel jobs?

0 Answers  

describe the Steps to confiure a Qlogic switch

0 Answers   IBM,

How do you import and export the datastage jobs?

0 Answers  

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

What is oci?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories