Saturday, February 2, 2013

Informatica Interview Questions on Normalizer Transformation



1. What is normalizer transformation?

The normalizer transformation receives a row that contains multiple-occurring columns and retruns a row for each instance of the multiple-occurring data. This means it converts column data in to row data. Normalizer is an active transformation.

2. Which transformation is required to process the cobol sources?

Since the cobol sources contain denormalzed data, normalizer transformation is used to normalize the cobol sources.

3. What is generated key and generated column id in a normalizer transformation?

  • The integration service increments the generated key sequence number each time it process a source row. When the source row contains a multiple-occurring column or a multiple-occurring group of columns, the normalizer transformation returns a row for each occurrence. Each row contains the same generated key value. 
  • The normalizer transformation has a generated column ID (GCID) port for each multiple-occurring column. The GCID is an index for the instance of the multiple-occurring data. For example, if a column occurs 3 times in a source record, the normalizer returns a value of 1,2 or 3 in the generated column ID.

4. What is VSAM?

VSAM (Virtual Storage Access Method) is a file access method for an IBM mainframe operating system. VSAM organize records in indexed or sequential flat files.

5. What is VSAM normalizer transformation?

The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition. A COBOL source is flat file that can contain multiple-occurring data and multiple types of records in the same file.

6. What is pipeline normalizer transformation?

Pipeline normalizer transformation processes multiple-occurring data from relational tables or flat files.

7. What is occurs clause and redefines clause in normalizer transformation?
Occurs clause is specified when the source row has a multiple-occurring columns.
A redefines clause is specified when the source has rows of multiple columns.


No comments:

Post a Comment

Thank you :
- kareem