Interested to Buy Any Domain ? << Click Here >> for more details...
What is operational data source (ODS)?
- 7 Answers
- 27462 Views
- I also Faced
- E-Mail Answers
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 |
Explain the aggregator transformation?
how to sort date field in infomatica?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
How to load query faster,so that It will take less time to load?
How does the session recovery work.
Can we get 1st record through Informatica(without sequence number).
scd methodology?
what transformations are used for Variable port?
Can we insert and update a target table without using update strategy transformation?How?
Which is the best place to learn Informatica Powercenter Online Training?
Teradata 
