Informatica INTERVIEW QUESTION & ANSWERS
| 96. |
What is the functionality of Repository server administration console? |
| |
Repository server administration console is used to create and administer the repository through the repository server. |
| 97. |
What is the difference between OLTP and ODS? |
| |
- OLTP is online transaction processing systems and ODS os operational database system. In OLTP we can save the current data, it depends on the day to day transactions and it stores the day to day data.
- In ODS we can store data for a month also and it is not restricted to a specific day or transaction.
|
| 98. |
What is sequence generator transformation? |
| |
Sequence Generator transformation is a Connected and an Passive transformation. The Sequence Generator transformation generates numeric values. You can use the Sequence Generator to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers. |
| 99. |
what is SCD? |
| |
SCD means Slowly Chnaging Dimension. If the values of attributes in a dimension table change over a period of time, then these dimensions are called slowly changing dimension. |
| 100. |
What are the types of SCD? |
| |
- Type 1 : In the dimensional table, the new data replaces the old data. In other words, the historical data is not preserved.
- Type 2 : New records are added to the dimension table. The old data is retained and the new records contain the new data.
- Type 3 : New fields are added to the dimension table so that the table can hold both old values and new values in the same record.
|
