diff between OLTP and OLAP?
what TOP-DOWN and BOTTOM-UP Approach? which is best?
what are Star Schema and Snow Flake Schema?
Answers were Sorted based on User's Feedback
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 |
Answer / 8686865797
OLTP databases are highly Normalized relational databases & OLAP databases are highly De normalized.
Is This Answer Correct ? | 0 Yes | 1 No |
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
Explain the scenarios where sequential file stage runs in parallel?
What is the difference between operational data stage (ods) and data warehouse?
what is the exact difference between dataset and fileset in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?