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
What is the session task and command task?
How to generate sequence numbers without using the sequence generator transformation?
what is the Default Source Option For Update Strategy Transformation?
What are the components of workflow manager?
Explain the etl program with few examples.
What is the difference between source qualifier transformations source filter to filter transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Difference between Target-based loading and constraint-based loading?
How many dimensions are there in informatica?
What is a grid in Informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is song in infrmatica...?
What differs when we choose the sorted input for aggregator transformation?
Parameter and variable differences
How would you join a node to the already existing domain?