What is sql override where do we use and which transformations

Showing Answers 1 - 6 of 6 Answers

sravangopisetty

  • Oct 10th, 2006
 

THe defualt Sql Return by the source qualifier can be over writne by using source qualifier.Transfermation is Source qualifier transfermation.

  Was this answer useful?  Yes

sravangopisetty

  • Oct 10th, 2006
 

2.look up transfermation3.Target

  Was this answer useful?  Yes

sn3508

  • Oct 26th, 2006
 

Besides the answers above, in Session properties -> transformations tab -> source qualifier ->SQL query - by default it will be the query from the mapping.  If you over write it, this is also called 'SQL override' 

  Was this answer useful?  Yes

vishal

  • Feb 16th, 2007
 

we use sql override for 3 transformationswhen the source is homo genious1. joiner transformation2. filter transformaton3. sorter transformation

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions