Informatica INTERVIEW QUESTION & ANSWERS
Data Warehousing
Follow Us
TAGS
| 91. | What is normalizer transformation? |
|---|---|
| Normalizer Transformation is an Active and Connected transformation. It is used mainly with COBOL sources where most of the time data is stored in denormalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data. |
| Posted by Anish Ranjan. (July 31, 2014) | |
Normalizer transformation can be used to Transpose the rows. |
| 92. | What is rank transformation? |
|---|---|
| Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data. |
| 93. | What is sorter transformation? |
|---|---|
| Sorter transformation is a Connected and an Active transformation. It allows to sort data either in ascending or descending order according to a specified field. |
| 94. | what is stored procedure transformation? |
|---|---|
| Stored Procedure transformation is an Passive & Connected or UnConnected transformation. It is useful to automate time-consuming tasks and it is also used in error handling, to drop and recreate indexes and to determine the space in database, a specialized calculation. |
| 95. | What is the difference between lookup and fact tables? |
|---|---|
| A lookup table contains information about the entities. In general the Dimension and details objects are derived from lookup tables. A fact table contains the statistical information about transactions. |