top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+3 votes
363 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
Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

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

+3 votes
Is it possible to get the SQL that would be generated, without running the mapping?

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.

...