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

Answer / 8686865797

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

How can we run same job in 1 day 2 times

7 Answers   IBM,

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

how to delete one row in target dataset

0 Answers   Satyam,

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

---

How to initialize environment variables?

4 Answers   Infosys,

---

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

---

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

2 Answers   TCS,

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---