What is sql query override? When did u use sql query override?
Answer / 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 |
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
What is the cumulative sum and moving sum?
How can i send first half of the records to one target and Remaining to other target?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Normalizer transformation is not involved in Mapplet.. why???
Differentiate between reusable transformation and mapplet.
how to import multiple flat files in to single target where there is no common column in the flat files
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
How to improve the performance of a session using sorter transformation?
What is exclusive and normal mode for repository services?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the difference between lookup override and souce qualifier override ?