What is operational data source (ODS)?
Answers were Sorted based on User's Feedback
Answer / tadikonda
ODS captures Day to day transactions .and u can generate
report on ODS
Is This Answer Correct ? | 24 Yes | 7 No |
Answer / mln
thsi is the data base used to captur daily business
activites and this is normalized databse.
Is This Answer Correct ? | 22 Yes | 9 No |
Answer / bidhar
ODS can be described as a snap shot of the OLTP system.It
acts as a source for EDW(Enterprise datawarehouse).ODS is
more normalised than the EDW.Also ODS doesnt store any
history.Normally the Dimension tables remain at the ODS
(SCD types can be applied in ODS)where as the Facts Flow
till the EDW.
More importantly Client report reqiurements determing what
or what not to have in ODS or EDW.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / rajshekhar
ODS is nothing but a staging area, in which you can keep
your OLTP type data like your day to day transactional data.
it is fully normalizied.
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / shivangi
ods(operation data source) is a main component of data
warehose which collects the data from different sources like
departmental data held by proprietary file systems etc.........
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / lakshmi
ODS : Operational Data Source. IT is just like OLTP. It will
maintain day to day transactions. In Some Organizations will
consider this as Data Back up or Data Recovery. When we are
loading the data we will take ODS tables as Source tables.
IT is Fully Normalized. Since it is normalized retrieving
the data will take time.Depend on the Organization they will
refresh the ODS.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / arun kumar
ODS is nothing but a staging area, in which you can keep
your OLTP type data like your day to day transactional data.
it is fully normalizied.
Is This Answer Correct ? | 3 Yes | 4 No |
What is degenerated dimention table?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
What is the use of code page?
How many types of sessions are there in informatica.please explain them?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
what is correlated query?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Explain the tuning lookup transformation - informatica