Condition to Check for NULLS and SPACES in Informatica

Scenario:

I have String data and I want to filter out NULLS and SPACES from that set of Data.
What can be the condition given in Informatica to check for NULLS and SPACES in ONE EXPRESSION OR FILTER TRANSFORMATION.

Solution:

Use LENGTH(LTRIM(RTRIM(column_name)))<>0 in filter transformation.

OR

IIF(ISNULL(column_name) or LTRIM(RTRIM(column_name)) = '', 0, 1) -- do this in exp t/n and use this flag in filte.

Comments

SQL Transformation with examples

============================================================================================= SQL Transformation with examples Use : SQL Transformation is a connected transformation used to process SQL queries in the midstream of a pipeline . We can insert, update, delete and retrieve rows from the database at run time using the SQL transformation. Use SQL transformation in script mode to run DDL (data definition language) statements like creating or dropping the tables. The following SQL statements can be used in the SQL transformation. Data Definition Statements (CREATE, ALTER, DROP, TRUNCATE, RENAME) DATA MANIPULATION statements (INSERT, UPDATE, DELETE, MERGE) DATA Retrieval Statement (SELECT) DATA Control Language Statements (GRANT, REVOKE) Transaction Control Statements (COMMIT, ROLLBACK) Scenario: Let’s say we want to create a temporary table in mapping while workflow is running for some intermediate calculation. We can use SQL transformat...

Convert Numeric Value to Date Format

...

Informatica Quiz: Set 1

...

Solution for Informatica problems

Search This Blog