What is the difference between an operational datastage and a data warehouse?
- 1 Answers
- 1260 Views
- I also Faced
- E-Mail Answers
Answer / Anurag Chandola
Operational Data Stage (ODS) primarily focuses on real-time processing of transactional data for immediate use, while Data Warehouse (DW) focuses on storing historical data for reporting, analysis, and decision making. ODS is often denormalized, optimized for speed, and updated frequently, whereas DW is normalized, optimized for querying, and typically undergoes periodic updates.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different options associated with dsjob command?
What is staging variable?
I have a few records just I want to store data in to targets cycling way how?
How can we run same job in 1 day 2 times
what is the difference between == and eq in UNIX shell scripting?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
source file contains 100 records, i want 10 records in target file how it possible in datastage
What are the partition techniques available in your last project?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
Teradata 
