3 Tricky Informatica Interview Questions

Here are interview questions little tricky to answer. I have collected these from a note where I usually save asked questions.

You May Also Like: Complete Informatica Questions and Answers.

1.What are the objects you can compare?

Sources-You can compare two sources, two source shortcuts, or a source with a source shortcut.

Targets-You can compare two targets, two target shortcuts, or a target with a target shortcut.

Transformations-You can compare two transformations, two transformation shortcuts, or a transformation with a transformation shortcut.

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.

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.

Folders– You can compare two folders in the Repository Manager.

Object shortcut versions-You can compare two versions of an object in the Repository Manager.

2. What are NaaN values?

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.

Operating systems and programming languages may represent NaN differently. For example the following list shows valid string representations of NaN:

nan NaN NaN% NAN NaNQ NaNS qNaN sNaN 1.#SNAN 1.#QNAN

The Integration Service converts QNAN values to #QNAN on Win64EMT platforms. #QNAN is a valid representation of NaN.

3. How does String conversion to integer works?

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.

Here is Informatica forum to Join : Informatica Network Groups

Related Posts

Author: Srini

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