What is sql query override? When did u use sql query override?
Answer Posted / santhosh
sql override is used to write sql select statements
sql override contains in source qualifier transformation
we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
Differentiate between router and filter transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
can u any challenge your project?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How many input parameters can exist in an unconnected lookup?
Write the unconnected lookup syntax and how to return more than one column.
How can you differentiate between powercenter and power map?
How to update or delete the rows in a target, which do not have key fields?
How to start a workflow using pmcmd command?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is difference between a gateway node and worker node?
r u done any partitions in ur project?
Explain why we use partitioning the session in informatica?
What is the difference between informatics 7x and 8x and what is latest version?