Informatica Useful Tips (Part1)

Tip 1 : Ignore the SQ SQL Override conditionallyIt is possible by defining a mapping parameter for the WHERE clause of the SQL Override. When you need all records from the source, define this parameter as 1=1 in theparameter file and in case you need only selected data, set the parameter accordingly.Tip 2 : Overcome size limit for a SQL Override in a PowerCenter mappingThe SQL editor for SQL query overrides has a limit of maximum of 32,767 characters.To overcome this we can do followingTo source a SQL of more than 32,767 characters do the following:1....

Read More

Informatica Metadata Queries (Part 2)

In this post we will continue with informatica metadata queriesPurpose : To Find Tracing Level for SessionQuery :select task_name,decode (attr_value,0,'None',1,'Terse',2,'Normal',3,'Verbose Initialisation',4,'Verbose Data','') Tracing_Levelfrom REP_SESS_CONFIG_PARM CFG,opb_task TSKWHERE CFG.SESSION_ID=TSK.TASK_IDand tsk.TASK_TYPE=68and attr_id=204 and attr_type=6Description : This query will give tracing information along with session names.This query is helpful in identifying the session which are having particular type of Tracing level like Verbose.Purpose...

Read More