top button
Flag Notify
Site Registration

How is it possible to access repository when the SQL and other transformations are not available?

+3 votes
261 views
How is it possible to access repository when the SQL and other transformations are not available?
posted Mar 3, 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 Mar 3, 2015 by Manikandan J
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.

...