11 G New Features

In this article we will cover new features of 11 G1) Case senstive Passwords : In 11G oracle password are case senstive ,but this feature can be changed by altering the parameter    ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;   2) Invisible indexes :In 11G we can make index invisible .Once we make index invisible it will be ignored by Optimiser CREATE INDEX index_name ON table_name(column_name) INVISIBLE;ALTER INDEX index_name INVISIBLE;Invisible index is useful in cases where you want to see the impact...

Read More

Informatica Metadata Queries (Part 3)

We will continue to publish new metadata queriesPurpose :  To Find Truncate Table OptionQuery : select task_name,'Truncate Target Table' ATTR,decode(attr_value,1,'Yes','No') Value  from OPB_EXTN_ATTR OEA,REP_ALL_TASKS RAT  where OEA.SESSION_ID=rat.TASK_ID and attr_id=9 Description : This query will give all sessions where Truncate Table Option is onPurpose : This query will give count of Mapping,Instance where Sqloverride has been doneQuery : WITH detail AS(SELECT c.subject_area, c.mapping_name,d.instance_name...

Read More

Informatica Strange Problems

Some time we encounter strange problem while working with informatica.I would like to highlight some problem  which no way seems to be logicalError : Informatica Debugger: Invalid session can not be debugged .Select a valid session instance to use  Problem : You are trying to run your mapping in debug mode by selecting valid session but you are getting below error even though your session is valid.Solution : 1)     ...

Read More

How to validate all mappings in a particular folder

In this post we will discuss how to validate all mapping in a particular folder Step1 : Go to the Repository manager client Step2 : Go to option Tools->Queries Create a new query with name  ALL_MAP_QUERY Create a query with parameter name and condition to retrieve the mappings in a folder as the following: folder = folder-name object type = mappingStep 3: a)      Connect to power center repository using...

Read More