Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
Explain why we use partitioning the session in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain sql transformation in script mode examples in informatica
What if the source is a flat-file?
How to call shell scripts from informatica?
What is flashback table ? Advance thanks
Write the prerequisite tasks to achieve the session partition?
Sequence generator, when you move from develoment to production how will you reset
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can repository reports be accessed without sql or other transformations?
What can we do to improve the performance of informatica aggregator transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the new features of Power Center 5.0?
