What is the difference between procedure and stored procedur?
Answer Posted / chandra
Both are the same.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the function of union transformation?
What are the limitations of joiner transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What if the source is a flat-file?
What are the guidelines to be followed while using union transformation?
What is target designer and target load order?
Can u generate reports in Informatica?
What are the advantages of using informatica as an etl tool over teradata?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a mapplet/worklet in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is workflow monitor?