What is the difference between operational data stage (ods) and data warehouse?
- 1 Answers
- 1340 Views
- I also Faced
- E-Mail Answers
Answer / Ravi Prakash Singh
The Operational Data Store (ODS) is a temporary, integrated data store used for operational reporting. It contains detailed transactional data that is not yet processed or transformed. A Data Warehouse, on the other hand, is a large, centralized repository of integrated data from one or more disparate sources, optimized for querying and analysis.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are fact tables and dimension tables? give example assuming one table.
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
How a routine is called in datastage job?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
What is ds designer?
How do you import and export data into datastage?
How to RD using transformer?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Name the different types of Lookups in Datastage?
How to generate surrogate key without using surrogate key stage?
What is a merge in datastage?
Teradata 
