What is the difference between iif and decode in informatica

Rafikul islam Posted October 12, 0 Comments. Viral Raichura Posted October 15, 0 Comments. Hi Swapnil, Download following free sample and see if that helps you.

Thanks, Satya. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. When you use DECODE, the datatype of the return value is always the same as the datatype of the result with the greatest precision.

For example, you have the following expression:. The return values in this expression are 5, 1. The first result is an Integer, and the other results are Decimal. The Decimal datatype has greater precision than Integer. This expression always writes the result as a Decimal.

When you run a session in high precision mode, if at least one result is Double, the datatype of the return value is Double. For example, the following expression is invalid:. When you validate the expression above, you receive the following error message:.

Function cannot resolve operands of ambiguously mismatching datatypes. Variable 1 was less than Variable 1 was 22!

Variable 2 was 49! Welcome back! Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign in with email Enter the email address associated with your account. You auth link is expired or incorrect, please try again.

Sign up with email Get the latest news, expert insights and market research, tailored to your interests. Sorter can be used to remove duplicates Use Distinct ouptut. We can remove duplicates using Rank. In sorter we cannot assign values to the ports. In rank we can assign variables and write non-aggregate expressions also. In sorter the Integration Service uses Sorter Cache to perform the sort operation.

In Rank the Integration Service stores group information in an index cache and row data in a data cache. Difference between ConnectedLookup and Unconnected Lookup. Connected Lookup. Unconnected Lookup. This is connected to pipleline and receives the input values from pipleline. Which is not connected to pipeline and receives input values from the result of a: LKP expression in another transformation via arguments.

We cannot use this lookup more than once in a mapping. We can use this transformation more than once within the mapping. We can return multiple columns from the same row. Designate one return port R , returns one column from each row. We can configure to use dynamic cache. We cannot configure to use dynamic cache. Pass multiple output values to another transformation. Pass one output value to another transformation.

Use a dynamic or static cache. Use a static cache. Supports user defined default values. Does not support user defined default values. Cache includes the lookup source column in the lookup condition and the lookup source columns that are output ports.

The difference betweenthe primary key and surrogate key: Primary Key : Primary key is a constraint on a column or set of columns in a table. A table can have only one primary key. Primary key ensures that the column s are unique and does not allow any NULL values in the column s. By default, the primary key creates a unique index on the column s. Primary key is defined on an existing column in the table.

Surrogate key : A surrogate key has multiple names. You can call a surrogate key as artificial key, integer key, non-natural key, synthetic key and so on. Simply put, surrogate keys are integers that are assigned sequentially as needed to populate a dimension table. When creating a table, an additional column is created on the table and a primary key constraint is defined upon that.

This new column is populated with sequence values. This is called the surrogate key. Differences between Stop and Abort. It continues processing, writing and committing the data to targets.