Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the tasks that can be performed using sq?
Explain the types of lookup transformation?
Explain lookup transformation is active in informatica
What is standalone command task?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is union transformation in informatica?
What are the different components of powercenter?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How many number of sessions can one group in batches?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How you know when to use a static cache and dynamic cache in lookup transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is workflow? What are the components of workflow manager?
Explain transaction control transformation in informatica
