Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nagaraju
push down optimization is used increase the performance.in this concept integration service convert the transformation logic into query and send to the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
How to elaborate powercenter integration service?
tell me the rules and responsblites in our project(my project is development)
Differentiate between Load Manager and DTM?
What are mapplets?
How to extract sap data using informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
list out all the transformations which use cache?
Can you generate sequence numbers without using the sequence generator transformation?
What are the differences between a connected lookup and unconnected lookup?
How can one identify whether mapping is correct or not without connecting session?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is decode in static cache?
What is workflow monitor?
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.
