Frequently asked Informatica Interview Questions part 1

There are few questions that are most confused while giving answers at the time of interviews. The aim of this post is to share those kind of questions to all the ETL developers. You can read the Complete Informatica Questions and Answers here.

  1. What are the objects you can compare?
    1. Sources-You can compare two sources, two source shortcuts, or a source with a source shortcut.
    2. Targets-You can compare two targets, two target shortcuts, or a target with a target shortcut.
    3. Transformations-You can compare two transformations, two transformation shortcuts, or a transformation with a transformation shortcut.
    4. Mappings and mapplets-You can compare two mappings, two mapping shortcuts, or a mapping with a mapping shortcut. You can also compare two mapplets, two mapplet shortcuts, or a mapplet with a mapplet shortcut.
    5. Instances-Within mappings and mapplets, you can compare two source instances, two target instances, or two transformations. Within mappings, you can also compare two mapplet instances.
    6. Folders– You can compare two folders in the Repository Manager.
    7. Object shortcut versions-You can compare two versions of an object in the Repository Manager.
  2. What are NaaN values?
    1. NaN (Not a Number) is a value that is usually returned as the result of an operation on invalid input operands, especially in floating-point calculations. For example, when an operation attempts to divide zero by zero, it returns a NaN result.
    2. Operating systems and programming languages may represent NaN differently. For example the following list shows valid string representations of NaN:
    3. nan NaN NaN% NAN NaNQ NaNS qNaN sNaN 1.#SNAN 1.#QNAN
    4. The Integration Service converts QNAN values to #QNAN on Win64EMT platforms. #QNAN is a valid representation of NaN.
  3. How String conversion into integer works?
    1. When the Integration Service performs implicit conversion of a string value to an integer value, it truncates the data at the first non-numeric character. For example, you link a string port that contains the value “9,000,000,000,000,000,000.777” to a Bigint port. The Integration Service converts the string to the bigint value 9,000,000,000,000,000,000.

Informatica forums : Informatica Network Groups

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.