Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any model difference between ODS and DWH
- 2 Answers
- 7342 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / vchandra
ODS stores operational data where as DWH store ODS data as
well as the history of the source database
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to update source definition?
How to create or import flat file definition in to the warehouse designer?
have u done any performance tuning? how u ll do?
What is meant by lookup transformation? Explain the types of lookup transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is an Integration service in Informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is depict expression change?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the components of workflow manager?
How do you use reject loader.
how we can load rejected record's at run time?(not through bad files)
