top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can repository reports be accessed without SQL or other transformations?

+3 votes
244 views
How can repository reports be accessed without SQL or other transformations?
posted Apr 1, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Repositoryreports are established by metadata reporter. There is no need of SQL or other transformation since it is a web app.

answer Apr 7, 2015 by Shweta Singh
Similar Questions
+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+3 votes

We can see the SQL's generated by PowerCenter in the session log file once a mapping has been run. So to get these SQLs we have to run the mapping. I would like to know if there is any way to get the SQL that PowerCenter would generate without actually running the mapping, so that we can analyse it, fix it or apply relevant database indexes etc. in case of any issues.

If this is possible then please tell me how.

...