Skip to main content

Posts

Showing posts from March, 2015

Queries in Informatica

Queries in informatica are useful in many ways. We can use it to identify mappings across repository in which a particular table is being used.We can use it to identify invalid objects in repository. We can use it to identify if any changes were made to objects on a given day.We even use them for deployment purpose this has been explained in earlier article. Please find the link below http://dwbuddy.blogspot.com/2014/01/labelling-and-creating-queries-in.html Suppose we know only table name and we want to know how it is populated and in which all mappings it is being used across informatica repository. We can achieve this by creating query in following way In repository manger go to tools there we will be having queries .Click new and give the parameters as mentioned in the screenshot Upon executing the query i.e. clicking the blue arrow icon all the mappings along with folder name which has table Employee being used will be displayed. Click save so that query can be used